I want to have the table change its dimension to whatever is picked up from the list box and display it as dimension for all the measures in the table. How can I achieve this.. I tried few things bt was not successful
Thanks in advance
write the value from the lustbox into a variable and assign the var as the dimision.
at the dimension.
hope that helps
Create one dimension entry for each of the dimensions, and use conditional display of the dimension. Use an expression like
=If(Concat(fieldname, ';') like '*this_dimension*', 1, 0)
For each dimension, replace the fieldname with the correct fieldname and the like string (*this_dimension*) with the value of the dimension in fieldname. Keep the wildcards *.
This approach allows you to select more than one dimension and display the table with one or two or more dimensions (or all dimensions for the Concat() option if nothing is selected).
Thanks for prompt reply. The solution you suggested looks good. Pls guide me more in detail. I tried using GetFieldSelections function bt seems not working.
Can you check if this is inline with what you are looking to get?
When we select Region from the Dim list box
When we select Country from Dim list box
Drawback of this approach is that you can only view one dimension at a time. So I have Dim list box 'Always One Selected Value Only' which will force it to only one selection at all times and won't even allow clearing it out as well.
Hello Sunny, this works like a charm.
Just realized, is this for Qlik Sense or QlikView?
I guess the concept will still work, but for list box you will have to use an extension which would allow you to restrict to only one selection at a time. Other than that, the method can be used in Qlik Sense as well.
Yeah Sunny, I agree..we need to use extension object for that purpose