topic Selections ignored when set analysis is used in QlikView

Selections ignored when set analysis is used

Mon, 31 Jul 2017 07:29:00 GMT

I have cut down my Qlikview application to its minimum and still cannot see why when I include set analysis {$} only, the existing selections are ignored.

Attached application DailySalesx.qvw has two charts which are the same except one has an expression =Sum(Period_01) the other =Sum({$}Period_01) . They should produce the same result. The one with {$} ignores the year selection, always showing both years

I have built the equivalent from scratch testgenericsa.qvw and it works fine.

Any suggestions?

Re: Selections ignored when set analysis is used

Frank_Hartmann — Mon, 31 Jul 2017 08:05:14 GMT

If you create a new sheet it will work

Strange behaviour !!!

Re: Selections ignored when set analysis is used

Frank_Hartmann — Mon, 31 Jul 2017 08:09:38 GMT

I figured out why its not working.

you have set up Alternate States. If you remove it then it will work on first sheet either

Re: Selections ignored when set analysis is used

ahaahaaha — Mon, 31 Jul 2017 08:18:00 GMT

Hi,

Transferring object List Box to the default state solves the task (look attached file).

Regards,

Andrey

Re: Selections ignored when set analysis is used

Mon, 31 Jul 2017 21:18:25 GMT

Frank and Andrey many thanks. When I started working with Qlikview I inherited applications and then used them as templates for subsequent applications propagating the problem. I was not aware of alternate state functionality so without unlimited time to play would not have solved it myself.