topic Re: Exclude Dimension.. in QlikView

Exclude Dimension..

vijayit43 — Tue, 18 Nov 2014 12:20:38 GMT

Hi,

In My QV is Dimension Field State & Brand and Expression field is Count(Retailercode) brands is Three Type A,B,C when Brand Dimension A then count B and C Brand Retailercode,when Brand Dimension B then count C and A Brand Retailercode when Brand Dimension C then count A and B Brand Retailercode How to Achieve It

Please Suggest

Re: Exclude Dimension..

Tue, 18 Nov 2014 23:25:53 GMT

Hi,

You can create a second brand field with the needed associations with the first brand.

For example:

Brands2:

Load * inline [

Brand2, Brand

A, B

A, C

B, A

B, C

C, A

C, B

];

This table will be linked to Brands table through field Brand.

In your chart, you can still use your current expression count(retailercode) and as dimension Brand2.

Hope this helps.

Re: Exclude Dimension..

vijayit43 — Wed, 19 Nov 2014 02:41:15 GMT

we dont change Brand in dimension because 5 other column in expression..