7 Replies Latest reply: Nov 8, 2017 9:00 AM by raffaele di francia

# How to get previous week metric data  in another metri

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

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

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

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

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

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

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

maybe this solution could be ok for you