Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
@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))