Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

State Function ::

Hello

I have the following expression which use the State :: function so that a table does not interact with a particular list box, called data_source_group.

However I want to know if it is possible in the same expression to write it so the expression does not interact with a second List box, and if so could someone kindly help me write the syntex

List Box 2 name = Stream

 

=Count({<data_source_group = State_1 :: data_source_group , FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} ED_ID)

Any help would be greatly appreciated

Thanks

Helen

2 Replies
MK_QSL
MVP
MVP

=Count({<data_source_group = State_1 :: data_source_group , FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}, Stream = >}ED_ID)

helen_pip
Creator III
Creator III
Author

Hello Manish

Thank you for your suggestion, but unfortunately this has not resolved my issue

Do you kindly have any further suggestions?

Kind Regards

Helen