Pivot table issue

Thu, 19 Jul 2012 15:10:56 GMT

Hi - I want to bring back all clients associated with selected NAICSDescription value even when no values in GPSMISTOT_REV field in a pivot table for a product. For ex, I have a Client ID and Client Name in my dimensions and expression is shown below.

It works if I select one NAICS Description value and it shows all clients associated with this NAICS even when there is zero using 'suppress zero values' unchecked.

But the problem is if I select one client then it does not bring back other clients associated that NAICS. It works only when there is a value in GPSMISTOT_Rev but does not show up if it's zero for products.

=sum({1<GPSDate={">=$(=date(yearstart(addmonths(max(GPSDate),-12)))) <=$(=date(max(GPSDate)))"},

GPSRegion = {'EMEA'},

GPSCardFilter={'0'},

NAICSDescription={"=NAICSDescription=NAICSDescription"}

>}GPSMISTOT_REV)

Any help pl?

topic Pivot table issue in QlikView

Pivot table issue