topic Re: Compare straight table vs. straight table in QlikView

Compare straight table vs. straight table

Anonymous — Wed, 25 Oct 2017 12:46:25 GMT

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

Re: Compare straight table vs. straight table

Anonymous — Wed, 25 Oct 2017 14:21:11 GMT

excel version attached for reference

Re: Compare straight table vs. straight table

Anil_Babu_Samineni — Wed, 25 Oct 2017 15:55:30 GMT

I think, Using Pivot table it is achievable ..

Re: Compare straight table vs. straight table

Anonymous — Thu, 26 Oct 2017 08:01:51 GMT

Thanks Anil, would it be 2 separate pivot tables?

Re: Compare straight table vs. straight table

Anil_Babu_Samineni — Thu, 26 Oct 2017 08:07:54 GMT

No, one table only

Re: Compare straight table vs. straight table

Anonymous — Thu, 26 Oct 2017 08:44:19 GMT

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

Re: Compare straight table vs. straight table

Anil_Babu_Samineni — Thu, 26 Oct 2017 08:48:41 GMT

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

Re: Compare straight table vs. straight table

Anonymous — Thu, 26 Oct 2017 12:17:27 GMT

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