Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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 !!
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 |
| |
Store F | 80 | 70 | Red downarrow | |
Store I | 109 | 110 | Green Upfilledarrow | |
Store H | 85 | 87 | Green Upfilledarrow | |
Store E | 130 | 140 | Green Upfilledarrow |
if expression tab you have a Green red and yellow arrow Please check and implement it.
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
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'')))