topic Date variables and set analysis in QlikView

Date variables and set analysis

Anonymous — Mon, 07 Sep 2015 12:02:08 GMT

Hello everyone,

I'm trying to use a date variable in set analysis but can't get it to work

This works perfectly:

Sum({< Date = {'07/09/2015'} >} RedFlag)

I have a variable, vDay1 that is set in the document as Max(Date) however I can't get it to show the correct figure:

Sum({< Date = {'$(=vDay1)'} >} RedFlag)

I know that set analysis can be tricky with date formats sometimes however Date and vDay1 should be the same format since vDay1 = Max(Date)?

What am I doing wrong?

PrashantSangle — Mon, 07 Sep 2015 12:04:47 GMT

Hi,

try with double quote " "

Sum({< Date={"$(=vDay1)"} >} RedFlag)

Regards

jonathandienst — Mon, 07 Sep 2015 12:05:59 GMT

Define vDay like this:

Set vDay1 = =Date(Max(Date), 'dd/MM/yyyy'); // note == is NOT a typo

Use like this

Sum({< Date = {'$(vDay1)'}>} RedFlag)

Or, if you prefer not to change the definition of vDay1, then rewrite the expression:

Sum({< Date = {"$(=Date(vDay1, 'dd/MM/yyyy'))'"}>} RedFlag)

sunilkumarqv — Mon, 07 Sep 2015 12:10:15 GMT

try this

Sum({< Date={"$(=$(vDay1))"} >} RedFlag)

Kushal_Chawda — Mon, 07 Sep 2015 12:11:58 GMT

Sum({< Date = {'$(=vDay1)'} >} RedFlag)

where vDay1= date(max(Date))

Sum({< Date = {"$(=date(max(Date)))"} >} RedFlag)