Solved: Set analysis muti contions - Qlik Community

tomcatxx · ‎2018-08-16

Hi, there. Can you help me to correct that expression? Thank you.

Conditions: Today()-8 <= %Datum < Today() and H.NAME1 = 'AA'

Measure: OK

Anil_Babu_Samineni · ‎2018-08-16

Perhaps this?

Count({<%Datum = {">=$(=Date(Today()-7))<$(=Date(Today()))"}, H.NAME1 = {'AA'} >} OK)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2018-08-16

Perhaps this?

Count({<%Datum = {">=$(=Date(Today()-7))<$(=Date(Today()))"}, H.NAME1 = {'AA'} >} OK)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

neelamsaroha157 · ‎2018-08-16

Count({<%Date ={">=$(vMinDate)<=$(vMaxDate)"},H.NAME1 = {'AA'}>}OK)

Create 2 variables as

vMinDate = Date(Today()-7)

vMaxDate = Date(Today())