Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Date range in set analysis help

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.

2 Replies
senpradip007
Valued Contributor III

Re: Date range in set analysis help

Try like:

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

MVP
MVP

Re: Date range in set analysis help

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.

Community Browser