Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two columns. Column A is the Identification number (ID 1,2,3 ... 10) and the second column B is a description of the ID. The column is called: 'Header'.
In the qliksense app I have a three sheets with 1) filterpane sorting on ID's and a Text & image chart.
What I need is an expression which allow me to fx click/filter on three ID's where each of my three sheets should show the 'Header' description on only one ID and not the same.
fx. When the filter pane is sorted on ID 1, ID 2 and ID 3 what I need is:
Sheet 1 needs to show: ID 1 = My Text & Image chart should only lookup the 'Header' for ID 1
Sheet 2 needs to show: ID 2 = My Text & Image chart should only lookup the 'Header' for ID 2
Sheet 3 needs to show: ID 3 = My Text & Image chart should only lookup the 'Header' for ID 3
Maybe something like this:
Only({<ID={$(=MAX(ID, 1 ))}>}Header)
Only({<ID={$(=MAX(ID, 2 ))}>}Header)
Only({<ID={$(=MAX(ID, 3 ))}>}Header)