QlikView App Dev

[helen_pip]

Hello

I have an expression, which uses 2 set analsysis within it

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

However if I place the {<data_source_group = State_1 :: data_source_group>} first, then this part interacts, and if I place {$<FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>}  in the expression first, then this interacts, but I cannot get the 2 too work together

Kind Regards

Helen

[jebamalai]

Try this and let me know

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

[tresesco · Accepted solution]

Try like:

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

[helen_pip]

Hello

I moved the $ sign to inside the set analysis, and the expression parsed, however it did not interact fully with my master calender

The alternative answer which interacts well with my matser calender is:

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

Thanks very much for your help

Thanks

Helen