topic Re: SetAnalysis not working? in QlikView

SetAnalysis not working?

Thu, 28 Apr 2016 06:47:02 GMT

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

Re: SetAnalysis not working?

Anonymous — Thu, 28 Apr 2016 06:54:02 GMT

Dear Niko,

Can you post the qvw sample,

So, we can see whats going on here.

Regards,

Winston

Re: SetAnalysis not working?

PrashantSangle — Thu, 28 Apr 2016 06:54:56 GMT

Hi,

Check your date format.

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

Post sample app if possible.

Kind Regards,

Re: SetAnalysis not working?

Peter_Cammaert — Thu, 28 Apr 2016 06:59:07 GMT

Maybe this works?

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

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

Re: SetAnalysis not working?

Thu, 28 Apr 2016 07:01:00 GMT

Well that did work, thank you very much! Amazing

Cheers,

Niko

Re: SetAnalysis not working?

Peter_Cammaert — Thu, 28 Apr 2016 07:21:10 GMT

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