Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

Overlapping values in dimension

Hi All,

I have a scenario like below.

I have to display four counts based on an indicator, the problem is that some counts can repeat like below.

flg1 flg2 flg3 flg 4                                flg1 count  flg2 count flg2 count flg3 count

y     y          n    n                                        2                       1                         0            0

y     n         n   n 

what is the best wat to display this. thinking about a dimension like type with four values and the numbers but the numbers should  overlapp. any thoughts.

2 Replies
Anil_Babu_Samineni

Flag1 is the base for other flags? I would always recommend to post 10 records with different values to understand more better

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jjustingkm
Creator II
Creator II
Author

They are all independent columns.  But the problem is that two id can be true for same id.

id  flg1 flg2 flg3 flg 4  

1     y     y          n    n                                        

2    y     n         n   n