Re: Compare straight table vs. straight table - Qlik Community

Anonymous · ‎2017-10-25

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

Anonymous · ‎2017-10-25

excel version attached for reference

Anil_Babu_Samineni · ‎2017-10-25

I think, Using Pivot table it is achievable ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-10-26

Thanks Anil, would it be 2 separate pivot tables?

Anil_Babu_Samineni · ‎2017-10-26

No, one table only

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-10-26

Can you advise the best way to add the variance into the pivot?

Anil_Babu_Samineni · ‎2017-10-26

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-10-26

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