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: 
Not applicable

Pivot table grouping issue

Hi,

i have a small issue with pivot table, i am use two expressions like actual and actual%. if i select period 1 actual and actual percentage displays perfect, if i select period 1,2,3, actual displays perfect but actual% not displays right values following is attachment

period 1                   actual           actual%

------------                 ------------         -----------

Gross Revenue         xxx              100%

Period 1               actual         actual%                Period2       actual         actual%              Period3           actual         actual%

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Gross Revenue      xxx            31%             Gross Revenue      xxx              33%             Gross Revenue    xxx              33%



i want each actuals also 100% please assist me

1 Reply
Not applicable
Author

this is my expression

exp.jpg