For exmaple: There is a dropdown selection which includes different vendors. I want to create an column chart of the first 5 vendors if no selection of a specific vendor is used. On the other hand if a vendor is selected in a dropdown menu i want to display only that vendor in the said column chart.
Thank you!
Yes, you can assign the dropdown selection to a variable and use that variable in case when clause in the column chart.
Thank you for your answer. And how can I integrate the statement CASE WHEN "drop down is empty" THEN...
is there a syntax for it or do I miss something here?
Best regards
Thank you for your answer. And how can I integrate the statement CASE WHEN "drop down is empty" THEN...
is there a syntax for it or do I miss something here?
Best regards
case when <%variable> is null then ... end
Unfortunately this doesnt work. An error occurs when no value is selected in the dropdown menu. The error disappears after I select a value.
Unfortunately this doesnt work. An error occurs when no value is selected in the dropdown menu. The error disappears after I select a value.
Sorry, please ignore earlier reply.
Below method will work, but it will apply the filter to the entire analysis and not to a specific component.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
