topic How to get previous week metric data in another metri in QlikView

How to get previous week metric data in another metri

Anonymous — Mon, 03 Apr 2017 06:49:14 GMT

Hi Team,

Good day

since last few days i am trying to achieve below mentioned issue in my dashboard

issue:

1.i need to display the previous metric data in another metric

2.again i need to subtract the current week data with previous metric data

EX:

in my issue i have date,previous week and current week fields

so now along with date i need to display previos and current week date

like below ;

Main table from Database:

Date current

5-march-2017 5

12-march-2017 8

19-march-2017 10

26-march-2017 15

Note:

Date columns contain only week data

out put table i need to show in dashboard:

Date current previous difference(currentweek-previousweek) metric

12-march-2017 8 5(this value is 5-march-current week data) 3

19-march-2017 10 8 2

26-march-2017 15 10 5

could you please suggest me how can i achive solution for this?

i have attached the QVW as well for same

Re: How to get previous week metric data in another metri

Anil_Babu_Samineni — Mon, 03 Apr 2017 10:01:34 GMT

How you are calculating the current week. Where you want to exclude the 5th of the date. What was the logic behind and reason should be there

Re: How to get previous week metric data in another metri

Anonymous — Mon, 03 Apr 2017 10:46:28 GMT

Hi anil,

please look on attached QVW file in earlier link then you can easily understand the logic of current and prev metric values in qlk .it just sum anb set analysis

Re: How to get previous week metric data in another metri

ahaahaaha — Mon, 03 Apr 2017 11:47:51 GMT

Hi,

May be like this if I right understand you (in attached file the table with red header background).

Regards,

Andrey

Re: How to get previous week metric data in another metri

ahaahaaha — Mon, 03 Apr 2017 11:53:42 GMT

I'm not sure that I correctly understood how many lines to output and how the date is determined in the top line.

Re: How to get previous week metric data in another metri

Anil_Babu_Samineni — Mon, 03 Apr 2017 12:49:52 GMT

It will work, Can i know the reason why you want to remove 5-march date. Because, by clue that we came to know the logic behind.

Note: I have seen and make sense too

Re: How to get previous week metric data in another metri

tsagarrao — Tue, 07 Nov 2017 12:08:36 GMT

Current Week=sum(Sales)

Previous week =Aggr(above((sum(Sales),date)

Trend:

Difference=sum(Sales)-Aggr(above(sum(Sales)),date)

You can restrict the date / data using variable or Aggr function in Demension level (Date) for last 4 dates , last 5 dates

Re: How to get previous week metric data in another metri

Anonymous — Wed, 08 Nov 2017 14:00:53 GMT

maybe this solution could be ok for you