Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhijith28
Creator II
Creator II

Table with Filter option in Qliksense

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.

abhijith28_0-1602759973439.png

But the output should be in  the below format.

abhijith28_1-1602760633435.png

 

In the above output.

Frequency of Name=2 and Frequency =1 

  • Name = A has 2 different ID i.e. 1 and 2, so Frequency will be 1

Frequency of Name=3 and Frequency =2

  • Name = B has 3 different ID i.e. 1,3 and 4 and also Name = C has 3 different ID i.e. 2,3 and 4

Frequency of Name=3 or More  and Frequency =2

  • Name = C and D has 4 or more different ID

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,

 

 

Labels (1)
13 Replies
sunny_talwar

@abhijith28 I guess you need to ignore selection in ID in your expression in that case.

abhijith28
Creator II
Creator II
Author

@sunny_talwar 

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,

 

sunny_talwar

@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)

 

abhijith28
Creator II
Creator II
Author

@sunny_talwar  Thanks 😊