topic Set analysis -- compare two dates in QlikView

Set analysis -- compare two dates

Thu, 17 May 2012 14:45:41 GMT

Hi!!
It's possible compare two dates in set analysis?

i would like to something like this:

Sum({< Data_Plan = {"<=$(Data_Ven)"} >} Valor)

I know it's possible do that using the (IF) condition, but it's possible with set analysis?

Best regards

Diogo Pereira

Re: Set analysis -- compare two dates

Miguel_Angel_Baeyens — Thu, 17 May 2012 14:50:35 GMT

Hi Diogo,

Both field Data_Plan and variable Data_Ven must have the same format. You can anyway try

Sum({< Data_Plan = {"<=$(=Date(Data_Ven))"} >} Valor)

but that will only work if Date(Data_Ven) has the same exact format as Data_Plan.

Hope that helps.

Miguel

Re: Set analysis -- compare two dates

IAMDV — Thu, 17 May 2012 14:52:51 GMT

Hi,

Please make sure that both the fields share the same date format. If not, you will have trouble matching the dates. I would recommend you to convert the field in Number format for easy matching. Because underlying dates in QV are just numbers. Probably you can use Dual() function to keep both the formats.

Cheers,