Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
It is necessary to restrict or limit the search option in Qliksense.
It contains the following data:
[Inline] [Loading
Code,ID
A,1
B,2
B,3
D,4
E,5
];
Here is how my Table Chart in Qlik Sensitive is configured: I am only showing data where the code is B, so I created a chart.
Where the Backend: if(Code='B',Code) is the same as the Qlik Dimension Backend: if(Code='B',Code) as BCode
expression I have used.
Output is this:
I see all records when I search by ID. Only records with code B of 2,3 should be displayed.
It would be greatly appreciated if you could help me with this issue. Thanks
Hello James,
If you change data model, you can add a new column for searching.
LOAD *, if(Code = 'B', ID) as IDsForCodeB;
[Inline] [Loading
Code,ID
A,1
B,2
B,3
D,4
E,5
];
I hope it solves.