topic Please Help Me, Select Single Dimension in QlikView

Please Help Me, Select Single Dimension

Anonymous — Tue, 26 Jan 2016 06:48:04 GMT

Hi Everyone,

I've question from this example table

How to view only Agent_Type = 1, in dimension for calculate some expresion...

Thanks for your help

sunny_talwar — Tue, 26 Jan 2016 17:24:45 GMT

Couple of ways.

1) Calculated Dimension: If(Agent_Type = 1, Agent_Type) and then select 'Suppress When Value Is Null' on the Dimensions tab.

2) Set Analysis within the Expression: {<Agent_Type = {1}>}