SetAnalysis not working?

[#1]

Hello,

I am trying to use set analysis to filter my pivot-table to show only the latest month data.

I am currently using the following statement:

Sum({<[Campaign]={'Campaign A'},  = {">$(=0)<$(=100)"}>} Value)

This statement works and it shows table. It is filterable with the datefield.

But when I try to add this datefield to the setanalysis thing, the table does not show anything anymore.

Sum({<[Campaign]={'Campaign A'},  = {">$(=0)<$(=100)"}, DateField={$(=Max(DateField))} >} Value)

Or if I use variable for that, same thing - nothing.

How is this possible that it does not show anything?

Is this solvable at somehow?

Cheers,

Niko

[Anonymous]

Dear Niko,

Can you post the qvw sample,

So, we can see whats going on here.

Regards,

Winston

[PrashantSangle]

Hi,

Check your date format.

is your dateField contain day to day value or monthly value??

Post sample app if possible.

Kind Regards,

[Peter_Cammaert · Accepted solution]

Maybe this works?

Sum({<[Campaign]={'Campaign A'},={">$(=0)<$(=100)"},

                                DateField={'$(=Date(Max(DateField)))'}>}Value)

[#5]

Well that did work, thank you very much! Amazing

Cheers,

Niko

[Peter_Cammaert]

To make it less cryptic to you: Set analysis assignments like this need the format of the values between braces to be exactly the same as the DateField format. Max() always returns a number which apparently is different from what DateField expects. The modification I proposed switches the date specification from numeric (number of days since...) to string (like D/MM/YYYY or whatever you have set as default).

Enjoy QlikView and the Qlik Community

Peter