Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different logic for every cell

Hi,

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

Please refer the example below -

CellLogic.PNG

How can i implement this in the expressions ?

2 Replies
Clever_Anjos
Employee
Employee

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

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

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

     Expr1,

     Expr2,

     ...)

- Marcus