topic Different logic for every cell in QlikView

Different logic for every cell

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to develop a dashboard where every cell is having a different logic to fetch the values

Please refer the example below -

How can i implement this in the expressions ?

Clever_Anjos — Tue, 16 Aug 2016 15:53:08 GMT

You can use Columno() and rowno() as reference

Pick(Columno(),

Rangesum(

If(Rowno() = 1, [Logic1]),

If(Rowno() = 2, [Logic2]),

If(Rowno() = 3, [Logic3]),

Rangesum(

If(Rowno() = 1, [Logic A]),

If(Rowno() = 2, [LogicB]),

If(Rowno() = 3, [LogicC])

)

marcus_sommer — Tue, 16 Aug 2016 15:53:42 GMT

You need to apply a pick(match()) combination like:

pick(match(Dimension, 'Dim1', 'Dim2', ...),

Expr1,

Expr2,

...)

- Marcus