Drill down to each detail level of data

[Swathi]

I have table, show the count falling on each combination . by clicking each on each cell of the cell, it should drill down to detail level of details of that table.

foe ex: where <-30 and cm2 >30, 6 customers are there . when on the click on the 6 cell, it should drill down to  detail level to see customer name, mail etc. how to do that

[vincent_ardiet_]

Have a look to the drill down master items: https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Dimensions/create-dr...

[Swathi]

@vincent_ardiet_ , Thanks for the reply, each cell in the column is the expression . by clicking on the cell , it should give of the cell in brief details . below one formula i have used for one column.

=pick(match(Name, '>30%', '{10%}-{30%}', '{0%}-{10%}', '{-10%}-{0%}','{-30%}-{-10%}','<-30%'),

$(vb1),

$(vb2),

$(vb3),

$(vb4),

$(vb5),
$(vb6))