Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All/ @sunny_talwar @Kushal_Chawda
I have a scenario but I am not sure whether its possible or not in Qlik Sense.
Below is the data set.
But the output should be in the below format.
In the above output.
Frequency of Name=2 and Frequency =1
Frequency of Name=3 and Frequency =2
Frequency of Name=3 or More and Frequency =2
And if the user selects on "Frequency of Name" the data should be filtered accordingly
For ex: if i select on "3 or More" the data should filter across the app.
Please help me on this scenario.
Please find the attached sample app.
Thanks,
@abhijith28 I guess you need to ignore selection in ID in your expression in that case.
I can use filter pane for the selections of ID and table for showing the measures 2,3 and 3 or More
For 2, i have used this measure :
Count(DISTINCT {<Name = {"=Count( ID) = 2"}>} Name)
Will this expression works fine?
Thanks,
@abhijith28 Try to change the expression to
Count(DISTINCT {<Name = {"=Count({<ID>}ID) = 2"}>} Name)
or
Count(DISTINCT {<Name = {"=Count({<ID>}ID) = 2"}, ID} Name)
@sunny_talwar Thanks 😊