Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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.