Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to replicate a view i have in excel into qlik view but not sure if its possible?
The idea is to compare one straight table, which displays last weeks data vs the previous weeks data & include a variance.
Cheers
Chris
excel version attached for reference
I think, Using Pivot table it is achievable ..
Thanks Anil, would it be 2 separate pivot tables?
No, one table only
Can you advise the best way to add the variance into the pivot?
I would ask you to share sample output and data set to test, I can do my best with my data but no use for you and wasting of time. Can you share sample
Attachment as requested.
The issues i have are trying to replicate the output tab in excel.
E.g
1) Do an equal comparison for wk vs wk. eg today (Thursday) i would like to compare Mon, Tues,Wed vs. previous Mon, Tues, Wed.
2) Adding a variance % at the end. (So you can see in excel wk vs. wk there is a 60% variance.
Thanks
Chris