How to choose which measure field to be displayed in a table just like using a filter?
Thanks for taking your time to read this. I have a very simple table with month as my dimension and let's say, cost and quantity as my measures.
I'm trying to create a filter pane or something similar which allows me to control which measure field to be displayed (like a filter);i.e.: I may just want cost only at this instance and quantity at another instance but I'm not sure whether you can do that in Qlik Sense. If yes, can someone please suggest a simple way to do so? Thank you very much!
For your information, I definitely need to have my month as the dimension as that is my top priority filtering field.
Re: How to choose which measure field to be displayed in a table just like using a filter?
Thanks for the help guys - appreciate it.
However, I have some minor issues with that approach:
1) It seems like I can only have one selection measure to be displayed per instance; i.e. when I try to select both measures (Cost & Quantity), the graph becomes blank but when I select them separately, they are displaying the right values.
2) The above approach works with measures that have just one word. I tried it on a measure with two words such as 'EX GST' and it's not displaying any values at all.
3) Will the approach work on a table rather than a chart? E.g.: removing the column of a measure when the measure is not selected. I have a feeling that it doesn't.
Having said that, I'm glad that I've learned something new and really wanna thank you guys for the help.