Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham174
Creator
Creator

Unique values need to show

Hi All,

 

Can you please help me to show this in 3 different table.

I.e 

Table 1 only top10

Table 2 only top20 which is not there in top10

table 3 only top30 which is not there in top10 and top20

 

Check.PNG

2 Solutions

Accepted Solutions
Channa
Specialist III
Specialist III

for table 3

for year below

=IF(Top30='Top30' and Top10<>'Top10' and Top20<>'Top20',Year)

 

measure

=if(Top10<>'Top10' and  Top20 <> 'Top20',Sum({<Top30={'Top30'}>}Sales))

Channa

View solution in original post

tresesco
MVP
MVP

Please try the below expressions:

Sum({<Sales =e({<Top10={'Top10'}>})>}Sales)
Sum({<Sales =e({<Top10={'Top10'}>}),Sales =e({<Top20={'Top20'}>}),Top30={'Top30'}>}Sales)

View solution in original post

6 Replies
Channa
Specialist III
Specialist III

year

if( not isnull(top10),year)

name

if( not isnull(top10),name)

top10

not isnull(topo10)

Channa
tresesco
MVP
MVP

Assuming  Top10, Top20, Top30  are fields as well as values to respective fields. Try like:

Table 1:  Sum({<Top10={'Top10'}>}Sales)

Table 2:  Sum({<Top10-={'Top10'},Top20={'Top20'}>}Sales)

Table 3:  Sum({<Top10-={'Top10'},Top20-={'Top20'}, Top30={'Top30'}>}Sales)

 

 

If this doen't help, try to share your sample app.

Gowtham174
Creator
Creator
Author

Tresesco

table 2 and table 3 values is showing 0

attached app for reference

Channa
Specialist III
Specialist III

i did for table 2 try did same for table 3

it is working

Channa
Channa
Specialist III
Specialist III

for table 3

for year below

=IF(Top30='Top30' and Top10<>'Top10' and Top20<>'Top20',Year)

 

measure

=if(Top10<>'Top10' and  Top20 <> 'Top20',Sum({<Top30={'Top30'}>}Sales))

Channa
tresesco
MVP
MVP

Please try the below expressions:

Sum({<Sales =e({<Top10={'Top10'}>})>}Sales)
Sum({<Sales =e({<Top10={'Top10'}>}),Sales =e({<Top20={'Top20'}>}),Top30={'Top30'}>}Sales)