Table with Filter option in Qliksense

[abhijith28]

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 

• 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,

[sunny_talwar]

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

[abhijith28]

@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 · Accepted solution]

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

@sunny_talwar  Thanks 😊