Discussion Board for collaboration related to QlikView App Development.
I have attached a file for the reference i have created the file with current and prev month data by using pivot in qlikview, now how can i calculate % change from Prior Month.
COuld you please help??
Go to Solution.
Would you be able to share a qvw sample to look at what are the dimensions and what are the expressions
PFA the sample QVW file for reference . I need a next column which shows % diff between 2 amounts (Jan- Feb).
there is only d2 where you have a value in both jan and feb month... are you hoping to get 150% for d2?
Have you seen the excel screenshot attached . I want qlikview in that format, these are random values hi have taken in test qvw file.
I want Feb all values by band then jan then the percenatge by band.
Please see attached excel i want qlikview graph in this format.
Here you go
Can you explain
LOAD * INLINE [
Just an island table used to create the view your are looking to get
Here you might find some other examples
Pivot Table Partial Percentage
Percent of Total in Pivot Table
Pivot table issue help