topic Date range in set analysis help in QlikView

Date range in set analysis help

Thu, 28 Aug 2014 03:27:37 GMT

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?

Re: Date range in set analysis help

senpradip007 — Thu, 28 Aug 2014 03:53:47 GMT

Try like:

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

Re: Date range in set analysis help

jagan — Thu, 28 Aug 2014 04:02:18 GMT

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.