topic set analysis expression in QlikView

set analysis expression

Wed, 25 Nov 2020 16:16:04 GMT

Hello

There is simple dataset

Data:

LOAD * INLINE [
Name, Value
A, 10
B, 20
C, 30
];

Need to create stright table with such results

The problem is to write the expression for “Value ProductB”

It is just the Value of Prosuct B

Let me know if you know how

sunny_talwar — Mon, 18 Sep 2017 18:28:35 GMT

May be this

Dimension

Name

Expressions

Value

Only(TOTAL {<Name = {'B'}>} Value)

Column(1) - Column(2)

Mon, 18 Sep 2017 19:45:16 GMT

Thanks,works!