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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
KevinQuGl
Contributor
Contributor

How do I make a table with only dimensions only display selected rows?

I have a table with a large number of rows of data that I need to have only display rows that have data that matches data in one or two columns.

For example, say I have columns Pa, Pu, & In; and my table has 300 rows of data.

When the user loads the Qlik Sense page, the table will only display the rows (Pa, Pn, In) that match one or both of the below values, rather than the full 300 rows of data.

Pa Pn
123 ABC
456 DEF
789 GHI
135 JKL

 

I am extremely new to Qlik Sense.  Please EiLI5 (Explain it like I'm 5).

Labels (1)
1 Reply
G3S
Creator III
Creator III

if it is a small list of values, you can try:

if(Pa='123' or Pa='456' or Pa='789' or Pa='135', pa)   . then uncheck the 'show null' tickbox. 

do the same for column Pn and In.