In my table there are two collums ( Journal ID and Journal ID Line number)
What i want to create is a KPI or something similar, that displays how many Journal IDs there are, that have more than 3 Line Numbers.
Unfortunately the values of the Line Numbers in the dataset are not correct. However, I can use the Count function in the table to show how many Line numbers each Jounal ID has.
Is there any possibility I can 'count the count' ?
With kind regards,
Solved! Go to Solution.
Will you be able to share your sample data file?
Count(distinct [Journal ID]) should give you count of Different Journal IDs and for
Journal IDs with more than 3 lines will be possible with Set Analysis and variable that will count lines number by Journal ID and using that variable to check it will be >= 3 for Journal IDs of the table
Hey, thank you for the fast Reply
The ideo to use set Analysis makes sense to me, however, i am not sure about how to implement it (im quite new to Qlik). Do you have any suggestions?
Here is the data.