Discussion board where members can get started with Qlik Sense.
i have created a filter pane with an if stetment in it, it works fine but the user can see the if statmet as the header of the filter pane.
is there a way to make my haeder 'x' not if(....)
You need to incorporate the If statement in the load itself. If you do it in a filter pane or a dimension of a chart its going to put the expression up as the label of the tile.
Thanks and Regards,
Can you try defining your dimension that is to be used as a filter with the IF statement as an actual "Dimension" in the Master Items list and let us know the behavior?
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
I have done as you have suggested but the result was the same.
I still get an Allies that is the filter name that I define in the title section and the if in the Ribbon section.
way is the Ribbon not showing the Allies? creating a new filter will be confusing to the user he will have 2 filters with the same data!
Same problem here, seems that label that you define for a calculated dimension is correctly shown when dimension is used on the dashboard, but not as the header of the filter pane, as you reported.
Moreover, even if calculated dimension is included as a Master Item, for those you can't define a label not equal to item name.
Hope that both of the above will be included in next release.
As a work around I would suggest you to have the if statement in the Load. This will help you improve the performance and get rid of the label problem as well.
Not sure if I got your question correct.
I have created a Filter with Field as if(Time='Day',PRODUCT_TYPE, PRODUCT_LINE)
and the label as if(Time='Day','Product Type','Product Line')
and it is working fine according to the selection... both the field and the label are changing.
Please let me know if this is not what you are looking for.
is the name of the filter on the selection Ribbon or is there an if?
if the Ribbon shows the if then its not solved.
This is how it looks
Even if I hover the mouse on the label, it still shows the label but not the condition/expression.
Did you try this way?