topic How to restrict my data in the filter object in App Development

How to restrict my data in the filter object

bhanu99 — Fri, 08 Sep 2023 18:44:08 GMT

The following is a example data

Channel	folder	subfolder
US	MAIN	JRM
US	IMP	UIO
US	SEMI	POK
GLOBAL	MAIN	MOP
GLOBAL	IMP	JIL
GLOBAL	SEMI	ENT
CH	MAIN	LUK
CH	IMP	AVU
CH	SEMI	PLI

I need to have two filters in my sheet, first filter should have values channel (just the field name), MAIN and SEMI. For this i created a inline code :

Load *
Inline
[
Filterdim,dimID
Channel,1
MAIN,2
SEMI,3
];

now my second filter has to be dependent on my first filter . if 'Channel' is choosed in my first filter i should get values of my channel column and if MAIN is selected then the respective values in subfolder (JRM,MOP,LUK) should come in my second filter , same goes for SEMI. how to achieve this

Re: How to restrict my data in the filter object

edwin — Wed, 13 Sep 2023 14:16:24 GMT

the qlik data model takes care of that for you:

Re: How to restrict my data in the filter object

bhanu99 — Wed, 13 Sep 2023 14:26:39 GMT

my first filter is 'channel''MAIN' and 'SEMI'.

If i select ' channel' then US,GLOBAL,CH should come in second filter. if i select 'MAIN ' then JRM,MOP,LUK in the second