topic Re: Pivot Table in QlikView

Pivot Table

sspawar88 — Sat, 11 Jul 2015 10:10:33 GMT

i have Pivot table in which dimensions are branch_type and region_name.

Expression consist

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count({1<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

Requirement is when i select on some region_name or branch_type.

i want only related items in Pivot table.

But now it gives all other items as o or Null.

what changes needs to be done?

Re: Pivot Table

swuehl — Sat, 11 Jul 2015 10:22:15 GMT

Please post a small sample QVW.

Re: Pivot Table

Anonymous — Sat, 11 Jul 2015 14:58:00 GMT

It should work as you described without any additional efforts. Maybe something is wrong with your data or data model. Can't tell without an example. Try if this returns anything:

count(param_value)/count(total param_value)