Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can do this using alternate states or using variables. See attached example.
What is SUM(A)?
A is Product or any measure value?
thanks for reply
A is a product and i want to do sum <A> (sales) - sum <B> (sales)
You can do this using alternate states or using variables. See attached example.
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.
thanks thanks
this is what i want