difference between the two products

[bbmmouha]

i have a problem and i need help

i'm a debutant

i have a dimension that contain products for exemple A B C D E F

i want to see the difference between the two products that he selected

for exemple if he selected A B

sum(A) - sum(b)

if he selected A C

sum(A) - sum(C)

thanks for help

[MK_QSL]

What is SUM(A)?

A is Product or any measure value?

[bbmmouha]

thanks for reply

A is a product and i want to do sum <A> (sales) - sum <B> (sales)

[Gysbert_Wassenaar · Accepted solution]

You can do this using alternate states or using variables. See attached example.

[Anonymous]

Hi,

You will have to use alternate states as you need to compare two selection from a unique field.

You can find some examples of how to use alternate states in the 'what's new in qlikview 11' demo document.

[bbmmouha]

thanks thanks

this is what i want