Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomcatxx
Creator
Creator

Set analysis muti contions

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

ex.PNG

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

Measure: OK

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

Perhaps this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neelamsaroha157
Specialist II
Specialist II

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

Create 2 variables as

vMinDate = Date(Today()-7)

vMaxDate = Date(Today())