Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date range in set analysis help

I'm trying to do set analysis and the date portion isn't doing anything... What is wrong with my syntax? I've attached the file - I tried it two ways.

In the attached file select Dim1 = A and Date = 8/28.

Selected sum Expression1 = 1449

Trying to do the same with set analysis but the sum =2050

='selected sum 1: ' & Sum (Expression1) & ' count of rows: ' & Count (Num) & ' Sum of expression1 where Dim1 = A and AccountStatus= Cancelled and date range: ' & Sum({1<Dim1={'A'},AccountStatus={'Cancelled'},date={">vStart<vEnd"}>}Expression1)

How do I fix this?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=Sum({<Dim1={'A'},AccountStatus={'Cancelled'},Date={">=$(=Date(vStart))<=$(=Date(vEnd))"}>}Expression1)

Note: Qlikview Field names are case sensitive, date and Date fields are not same.  You have to give correct case.

Regards,

Jagan.

View solution in original post

2 Replies
senpradip007
Specialist III
Specialist III

Try like:

Sum({1<Dim1={'A'},AccountStatus={'Cancelled'},date={">$(vStart) <$(vEnd)"}>}Expression1)

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=Sum({<Dim1={'A'},AccountStatus={'Cancelled'},Date={">=$(=Date(vStart))<=$(=Date(vEnd))"}>}Expression1)

Note: Qlikview Field names are case sensitive, date and Date fields are not same.  You have to give correct case.

Regards,

Jagan.