Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Contributor III
Contributor III

Set analysis based on field selection

I am creating a generic flag filter and need to use the value in multiple places. The below set analysis is working , but the issue is there is no selection i need to ignore the flag condition or flag value should be assigned both

values 'Y' and 'N'. Any help is appreciated.

count({<Order_flg={$(=chr(39)&GetFieldSelections(order,chr(39)&','&chr(39))&chr(39))}>} Order_ID)

2 Solutions

Accepted Solutions
Ksrinivasan
Specialist
Specialist

hi,

try this

=if(GetSelectedCount(Order_flg) = 0, '0', count({<Order_flg={$(=chr(39)&GetFieldSelections(order,chr(39)&','&chr(39))&chr(39))}>} Order_ID))

ksrinivasan.

 

View solution in original post

jjustingkm
Contributor III
Contributor III
Author

I got my variable working and need to try the one posted here. looks simpler.

View solution in original post

3 Replies
Ksrinivasan
Specialist
Specialist

hi,

try this

=if(GetSelectedCount(Order_flg) = 0, '0', count({<Order_flg={$(=chr(39)&GetFieldSelections(order,chr(39)&','&chr(39))&chr(39))}>} Order_ID))

ksrinivasan.

 

View solution in original post

marcus_sommer
MVP & Luminary
MVP & Luminary

Change it to: count({<Order_flg=p(order)>} Order_ID)

- Marcus

jjustingkm
Contributor III
Contributor III
Author

I got my variable working and need to try the one posted here. looks simpler.

View solution in original post