Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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)

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)

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())