Hi,
is the following somehow possible?
Suppose I have a dashboard variable prompt, let's say presentation variable PV_CHOICE with the custom values “yes” and “no”.
In my analysis I want to build a column referring to the prompt selection of the variable prompt, something like
"… case when @{PV_CHOICE} = ‘yes’ then ‘column 1’ else 'column 2' end.
The dashboard contains the variable prompt and the analysis.
I know that it works for column prompts, and I don't want to use a filter or a combined analysis.
When I try it, I get
Nonexistent column: "yes". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT CASE WHEN yes= ''yes'' THEN ''column 1'' ELSE ‘’column 2'' END FROM …)}
Thanks in advance.