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: 
abc_18
Creator II
Creator II

how to show only few conditional dimension values in a table

Hi,

I have a straight table chart as below, where in dimension have to show Number and Version by joining them.

Another column is p which shows the pth numbers.

Number - Version p Total
20.0.18362-May 2019 update p-3 5
20.0.18363-June 2019 update p-2 3
20.0.19363-June 2019 update-22H2-May 2020 update p-1 13
20.0.19363-update-23H2 p+1 52
20.0.19362-update-23H1 p+2 4
20.0.20000-update p 83
Greater than 20.0.20000-update p+ 9

Now requirement is like this table should show only the values of “p”, “p-1”, and “p+”. For the row that is being aggregated which is the “p+”, this should show the values greater than 20000 .

for this I am writing below condition but unable to eliminate other values from table. ideally only three rows should be there along with additional 10p+ values

=if([number]='Greater than 20.0.20000','p+',
if(version='update-23H2','10p+',
if(version='update-23H1','10p+',
if([number]= SubField('20.0.20000','.',3),'p',
p))))

Please suggest what changes do I need to make in expression.

Labels (2)
0 Replies