Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way to overwrite the always select one value for some pages of the app?
I want one value selected in a field for all pages for an app except a few. However, the always one selected value does not allow more than one selection in any page of the app.
Is there a way to overwrite this? Or a workaround for this?
There is no way to overwrite this
and another work around other than what @Aditya_Chitale told could be to use variable.
You could use set variable value to a particular value and then use variable input to select the value which only selects one, And you can set the values to be dynamic in variable input.
after that in you set expression you could use
Field = {$(=variable)}
You cannot make that work only for specific sheets however one workaround would be to create duplicates of the same field and rename them differently so as to make same selections and apply different selection settings.
Though, a drawback of this would be that you will be able to see multiple field selection tabs on top of your sheet.
Regards,
Aditya
@Aditya_Chitale Even though the new field will not have any selections, the original field would still have one selected value and the charts would be filtered according to that selection. I am trying to not let that happen. Any ideas?
to ignore selections, you need to use the concept of nullification in your measure expression. Refer below link to understand the topic in detail:
Nullification in Set Analysis..?? - Qlik Community - 1100337
Regards,
Aditya
There is no way to overwrite this
and another work around other than what @Aditya_Chitale told could be to use variable.
You could use set variable value to a particular value and then use variable input to select the value which only selects one, And you can set the values to be dynamic in variable input.
after that in you set expression you could use
Field = {$(=variable)}