Create a filter with values only related to another field

[sily_salmon]

Hi All,

I'm a beginner in QlikSense and still learning concepts around scripting.

I have a table like the one below,

Attribute Type	Attribute
Type	Ad
Type	Program
Channel	SMS
Channel	EMAIL
Status	Sent
Status	Pending

Now I want to create filters from the above table like,

Channel

SMS

EMAIL

Status

Sent

Pending

Please suggest a way to do this.

Thanks,

[vinieme12 · Accepted solution]

as below

temp:
load * inline [
Attribute Type,Attribute
Type,Ad
Type,Program
Channel,SMS
Channel,EMAIL
Status,Sent
Status,Pending
];

for each attr in FieldValueList('Attribute Type')
$(attr):
Load Attribute as [$(attr)]
Resident temp
Where [Attribute Type]='$(attr)';
next

drop table  temp;
exit Script;

[sily_salmon]

Thanks @vinieme12 , Your solution worked!