topic Re: How can i compare the same stores from two different periods in QlikView

How can i compare the same stores from two different periods

geogou1973 — Mon, 22 Jan 2018 14:25:48 GMT

Hello.

I have two tables one for the sales of 2017 and the other for the sales of 2015 with the same fields

like date, store, amount and i concatenate them. In a chart i want to compare only the stores that 2017 has with the same of 2015. In 2015 i have more stores and i don't want them in the chart. In one expression i have the data for 2017 and in the other expression i have the data from 2015.

How can i do this ?

Thank you in advance.

Re: How can i compare the same stores from two different periods

Ralf_Heukäufer — Mon, 22 Jan 2018 14:42:27 GMT

Hello Gou,

can you write how your table construction looks exactly?

Re: How can i compare the same stores from two different periods

Anil_Babu_Samineni — Mon, 22 Jan 2018 14:44:40 GMT

First one you have to choose Bar chart to compare year analysis. And, Then measures looks like

1) Sum({<Year = {2015}>} Measure)

2) Sum({<Year = {2017}>} Measure)

Re: How can i compare the same stores from two different periods

geogou1973 — Mon, 22 Jan 2018 14:50:16 GMT

date store amount

01/03/2015 101 1.000

01/03/2015 103 4.000

01/03/2015 105 3.000

04/03/2015 105 2.000

date store amount

01/03/2017 101 1.000

01/03/2017 103 4.000

04/03/2017 105 2.000

I want to have for example for the date 01/03/2017 the stores 101 and 103 and for the period 01/03/2015 the same stores 101 and 103 not the 105

Re: How can i compare the same stores from two different periods

geogou1973 — Mon, 22 Jan 2018 14:55:54 GMT

Hello Anil.

In the first expression i will have all the stores that the 2015 has and i don't want it. I want to have only the stores that the 2017 has.

Re: How can i compare the same stores from two different periods

swuehl — Mon, 22 Jan 2018 14:57:31 GMT

1) Sum({<Year = {2015}, Store = p({<Year = {2017}>}) >} Measure)

2) Sum({<Year = {2017}>} Measure)

Re: How can i compare the same stores from two different periods

geogou1973 — Mon, 22 Jan 2018 15:17:33 GMT

It is correct.

Thank you very match Stefan.