topic Re: Pivot Table Data Restriction in QlikView

Pivot Table Data Restriction

Anonymous — Tue, 13 Dec 2016 08:26:04 GMT

Hi Team,

I need to restrict the data in the table to show only the Airlines having more than one between the Source and Destination.

I have posted my sample source data and required data.

Any ideas on achieving this?

Thanks in Advance.Please let me know if you need more details.

Thanks

Source Data:

Required Data:

Gysbert_Wassenaar — Tue, 13 Dec 2016 08:33:30 GMT

Try a calculated dimension as a replacement for Destination: =If(aggr(Count(Distinct Airline),Destination)>1,Destination)

Or change your chart expressions. For example sum(Amount) would become sum({<Destination={"=count(distinct Airline)>1"}>}Amount)

asgardd2 — Tue, 13 Dec 2016 08:39:50 GMT

Hello!

I think you need to use aggr() function in dimension. (and turn on option "Suppress When value is Null")

IF(Aggr(Count(Distinct Airline), Destination,Origin) > 1, Destination)

qlikviewforum — Mon, 18 Mar 2019 12:41:04 GMT

Both the above solution doesn't seems to be working for me. Only the below seems to be working for me.

IF(Aggr(Count(Distinct Airline), Destination,Origin) > 1, Destination)