Help Needed for Calculated Dimension/Set Analysis

Mon, 08 Feb 2016 14:57:31 GMT

Hi, I would like to write a set analysis in which I can create a new column called AllChange. It would be great if this can be done with calculate dimensions instead of the script. So, if the price changed for all products in that specific type, then "yes" in the AllChange column. If you look at the sample data below, A is all "yes" because all products within that type changed in price. For Type B, product 2 did not change in price and therefore AllChange for all products within Type B would be No.

Original Table Structure:

Product Price Change Type

1 $10 A

2 $15 A

3 -$30 A

4 -$40 A

1 $20 B

2 $0 B

3 -$18 B

4 -$20 B

New Table Structure

Product Price Change Type AllChange?

1 $10 A Yes

2 $15 A Yes

3 -$30 A Yes

4 -$40 A Yes

1 $20 B No

2 $0 B No

3 -$18 B No

4 -$20 B No

I look forward to any assistance I can get. Thank you for your time!

Re: Help Needed for Calculated Dimension/Set Analysis

sunny_talwar — Mon, 08 Feb 2016 16:48:01 GMT

May be this:

=If(Sum(TOTAL <Type> Aggr(If([Price Change] = 0, 1), Product, Type)) > 0, 'No', 'Yes')

topic Re: Help Needed for Calculated Dimension/Set Analysis in QlikView

Help Needed for Calculated Dimension/Set Analysis

Re: Help Needed for Calculated Dimension/Set Analysis