topic Re: difference between the two products in QlikView

difference between the two products

bbmmouha — Mon, 02 Mar 2015 10:29:44 GMT

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 — Mon, 02 Mar 2015 10:41:26 GMT

What is SUM(A)?

A is Product or any measure value?

bbmmouha — Mon, 02 Mar 2015 10:48:13 GMT

thanks for reply

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

Gysbert_Wassenaar — Mon, 02 Mar 2015 10:48:31 GMT

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

Anonymous — Mon, 02 Mar 2015 10:51:02 GMT

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 — Mon, 02 Mar 2015 10:54:03 GMT

thanks thanks

this is what i want