Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've the below table along with the qlikview document(personal edition). I'm using master calendar in my load script.
Table:
---------------
Value | Date | Amount |
A | 01/01/2018 | 100 |
A | 02/01/2018 | 140 |
A | 03/01/2018 | 230 |
A | 04/01/2018 | 460 |
A | 10/01/2018 | 220 |
A | 11/01/2018 | 120 |
A | 12/01/2018 | 234 |
A | 13/01/2018 | 430 |
A | 16/01/2018 | 111 |
A | 17/01/2018 | 345 |
A | 18/01/2018 | 230 |
A | 23/01/2018 | 235 |
A | 24/01/2018 | 120 |
A | 25/01/2018 | 420 |
Now my requirement is i'm looking for an expression which returns only particular weeks sum of amount. Example if I define only first week in the expression then the sum will be '930' because 01/01/2018,02/01/2018,03/01/2018,04/01/2018 is from week1.
Lol, I think you really don't want to review your set analysis basics...
=Sum({<Week = {"$(=Min(Week))"}>}Amount)
May be this
=Sum({<Week = {1}>}Amount)
That's working perfect Sunny, thanks for that. If is select or not select 1st week it is returning the sum amount for week 1.
in this expression we are defining 1 manually and now my requirement is instead of defining the value manually it has to dynamically, i mean if we select 1-2018 in WeekYear list box the output has to be 930, if we select 2-2018 in WeekYear list box the value has to change to 1004 and so on.
Lol, I think you really don't want to review your set analysis basics...
=Sum({<Week = {"$(=Min(Week))"}>}Amount)
Haha, lot's happening in my mind and couldn't recollect...
Thanks for that mate and is working fine.
Take a step back and get the basics right. I don't think anybody minds helping you out with simplest of questions, but do this for your own learning is what I am trying to suggest