Sort table by measure

[joep_026]

Hello everyone,

Currently I am working on a Qliksense dashboard. I want to be able to filter my table by data measure (for example either by Stock, Sales or Cost Value). Now I see al those 3 values in the same column and I'm not able to see just the one I want to see.

I've researched online but I cannot find the answer. also, regular filter doesn't work.

I'm looking forward to an answer!

Enclosed: My table with the problem that I face.

[Anil_Babu_Samineni]

You want all measure either in ascending / descending order? If so, can we get sample file to work with you

[joep_026]

No I just want to be able to filter by measure: So see either Sales, Stock or Value instead of all 3 at the same time.

Also, I'm afraid I can't share the data set as it is company secret information.

[Anil_Babu_Samineni]

First thing, We never ask real time data as you can think and share the sample data

second thing, On what condition those three need to be disable? Let's say If you can one thing from Dimension where you can define in the expansion of Measure with If(GetSelectedCount(Dimension)>1,1,0) from "Show Column If" condition

[joep_026]

Well I want a sort of filter next to the table, in which you can select te value (Either Sales, Stock or Value) if it is possible.

[Anil_Babu_Samineni]

Create filter pane for all three measures differently and use self for them. 

[joep_026]

The problem is, if I create a filter it will just be able to filter by the possible values instead of the measures.

See enclosed. Therefore I am not able to filter by either of the data measures

[Anil_Babu_Samineni]

By any chance, are you looking kind of this report?

https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/

[joep_026]

Exactly. But you said it is also possible with 'Show column if' right? Maybe it is possible to create your own 'Filter pane' using this?

[Anil_Babu_Samineni · Accepted solution]

How-to-create-ad-hoc-Reports-in-Qliksense/