Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

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
Creator II
Creator II
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.

 

marcus_sommer

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

- Marcus

jjustingkm
Creator II
Creator II
Author

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