topic Re: Compare Lastweek with Currentweek and difference should be shown in arrow in QlikView

Compare Lastweek with Currentweek and difference should be shown in arrow

priya945 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please help me with expression for below output. Compare Lastweek with Currentweek and difference should be shown in arrow

a. Negative change then Red downarrow

b. Positive change then Green Upfilledarrow

Thanks In advance.

Priya

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

simenkg — Tue, 03 Jul 2018 10:16:55 GMT

if([Current Week] - [Last Week] >0

,'qmem://<bundled>/BuiltIn/arrow_n_g.png',

'qmem://<bundled>/BuiltIn/arrow_s_r.png')

Then change representation to: "image" and Image formatting to the desired fill effect.

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

priya945 — Tue, 03 Jul 2018 10:24:45 GMT

Thanks Simen for quick reply but my requirement is to compare Lastweek with Currentweek

a. if the Currentweek value is greater than Lastweek then green arrow

b. if the Currentweek value is less than Lastweek then red arrow

c. No change then <> in yellow

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

vipin_mishra479 — Tue, 03 Jul 2018 10:35:32 GMT

First calculate the current week

vCurrentWeek = Max(Week)

vLastWeek = Max(Week)-1

The use Expression

Exp1 :- Current Week Data = Sum({<Week = {vCurrentWeek}>}Amount)

Exp 2 :- Last Week Data = Sum({<Week = {vLastWeek}>}Amount)

if(Sum({<Week = {vCurrentWeek}>}Amount) - Sum({<Week = {vLastWeek}>}Amount) >0

,'qmem://<bundled>/BuiltIn/arrow_n_g.png',

if(Sum({<Week = {vCurrentWeek}>}Amount) - Sum({<Week = {vLastWeek}>}Amount) <0

'qmem://<bundled>/BuiltIn/arrow_s_r.png'),

'qmem://<bundled>/BuiltIn/arrow_k_g.png'),

Hope this will help !!

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

priya945 — Tue, 03 Jul 2018 10:43:44 GMT

Here is my requirement

a. if the Currentweek value is greater than Lastweek then green arrow

b. if the Currentweek value is less than Lastweek then red arrow

c. No change then <> in yellow

Store name

Last Week

Current Week

Store C

130

110

Red downarrow

Store F

Red downarrow

Store I

109

110

Green Upfilledarrow

Store H

Green Upfilledarrow

Store E

130

140

Green Upfilledarrow

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

vipin_mishra479 — Tue, 03 Jul 2018 11:39:18 GMT

if expression tab you have a Green red and yellow arrow Please check and implement it.

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

priya945 — Tue, 03 Jul 2018 12:09:44 GMT

I have managed to get the below expression

=if(SUM({$<Week = {$(=MAX(Week))}>}Value)>SUM({$<Week = {$(=MAX(Week)-1)}>}Value), 'G',
(if(SUM({$<Week = {$(=MAX(Week))}>}Value)<
SUM({$<Week = {$(=MAX(Week)-1)}>}Value), 'R', 'N')))

But I need to replace G,R,N with arrow marks. i am new to qlikview please suggest how to replace

Re: Compare Lastweek with Currentweek and difference should be shown in arrow

sujan24s — Tue, 03 Jul 2018 13:08:48 GMT

Hi,

can you check this

=if(SUM({$<Week = {$(=MAX(Week))}>}Value)>SUM({$<Week = {$(=MAX(Week)-1)}>}Value), ''qmem://<bundled>/BuiltIn/arrow_n_g.png'',
(if(SUM({$<Week = {$(=MAX(Week))}>}Value)<
SUM({$<Week = {$(=MAX(Week)-1)}>}Value), ''qmem://<bundled>/BuiltIn/arrow_n_g.png'', ''qmem://<bundled>/BuiltIn/arrow_s_r.png'')))