topic Logic in QlikView

Logic

sona_sa — Tue, 30 Dec 2014 14:32:44 GMT

Hi,

I have a pivot table, all the selection are working fine but for section selection it is not displaying selected data.

For reference please check the attached qvw.

Thanks.

Re: Logic

NickHoff — Tue, 30 Dec 2014 14:47:40 GMT

Hey Akumar,

I recall coming about this problem when working with alternate states. The solution was within the set you have to use ::.

An example would be Section1=$::Section1 inside your set.

Although it might not be clear without knowing the data below is an example of my full expression:

SUM({SetA<@Refined2IND={$(vRefined)},CalendarYear=$::CalendarYear,CalendarQuarter=$::CalendarQuarter,CalendarMonth=$::CalendarMonth,PhysicianRole=$::PhysicianRole>}Cases)

Re: Logic

sona_sa — Tue, 30 Dec 2014 16:33:46 GMT

Hi Nick,

I didn't got u'r point. I would like to know is it possible in this expression or I have to make any changes on the same expression. I have attached my apps in the same, can u do something on that.

Thanks for reply.

Re: Logic

Tue, 30 Dec 2014 21:09:45 GMT

You have some synthetic keys. Maybe you can try getting rid of them and see how it behaves?

Re: Logic

sona_sa — Wed, 31 Dec 2014 05:30:59 GMT

Hi Ajay,

Thanks for your valuable time, I know there is synthetic key, But it is working for another selection like Format / Source Name / Trans Type Name / Department / Country, Only not working for Section or Section 1.

Thanks Again.