Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
As a user of Qliksense, I would like to restrict or limit the data that is displayed when searching.
Data amount:
Load * Inline [
Code,ID
A,1
B,2
B,3
D,4
E,5
];
In Qlik Sense, I have created a Table Chart, where I need only the data from where Code = B to display, and I created a
If Code='B',Code) is the same as BCode into the Qlik Dimensions Backend or front end?
This is the expression I used.
The output is as follows:
When I search by ID, I see all the records. Only records with code B of 2,3 should be displayed.
If you could assist me in this matter, I would greatly appreciate it. Thanks
Hi @markwelder , one option is to create another table with data filtered, then use the new field to use in chart and make searches.
Data amount:
Load * Inline [
Code,ID
A,1
B,2
B,3
D,4
E,5
];
DataB:
Load
ID,
Code as CodeB
Resident [Data amount]
Where
Code = 'B';