Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to calculate percentage growth for mens ladies etc in this report
Provide sample data or sample app to work.
Otherwise you can search for Above and Before function in Qlik
Hi
Here in above image i want to calculate boys growth % for season 17P AND 18P ie.(872)-(788)/(788)?
I Dont see what dis has to do with Qlik but i suppose you wat to calculate the percentage increase from 17P to 18P.
You can do that by dividing the P18 value by the P17 value times 100% (in your case: 872/788*100%).
I hope the problem is that because you are using pivot table you cant achieve what you looking around !!
You can able to achieve in Straight table
But I want Season in same format which can't be achieved in straight table
Can you provide us sample data and output you are looking for in excel file?
Hi
I want to compare between two seasons so i am using following expression
=num(sum({<Year ={"$(=Max(Season_Code))"}>}quantity_sold),'#,##0.0')
but its not functioning.
What will be the correct expression ?