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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Pujitha
Contributor II
Contributor II

Pivot table

Hello all,

I have a question- I need to create a pivot table for which I need to show >30 days >60days >100 days (in rows)like that I need to show the count of those cases like[(50) in top column)and then If i expand near >30days those case numbers(with count 50 display at the top) I need to show up same way in another >60 days if I xepand it i need to show all the case numbers. In another cloumn I need to show avg and percentage too.please help. VEry urgent.

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

i think you need to use valuelist

check below

ValueList() – For those tricky situations