topic Re: State Function :: in QlikView

State Function ::

helen_pip — Thu, 18 Sep 2014 07:59:32 GMT

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

Re: State Function ::

MK_QSL — Thu, 18 Sep 2014 08:06:27 GMT

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

Re: State Function ::

helen_pip — Thu, 18 Sep 2014 09:45:25 GMT

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