Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Please help me on the below,
Month | Category | field |
Aug-17 | A | H |
Sep2017 | B | I |
Nov-17 | C | G |
Dec2017 | D | K |
Jan-18 | E | L |
Fe b2018 | F | M |
Mar-18 | G | N |
it is my final data.
I want to show the latest 5 month data.
Why are some of your months MMM-YY and Other MMMYYYY ?
Anyways, you can use a where clause to handle this
WHERE DateField >= MonthStart(Today(), 5);
Thanks for the reply.
but i am getting same data only.
Can you share the script you tried
Please find it below.
LOAD
Category,val,GYR_Month,MonthName(GYR_Month) as GYR_Month1,
field1
Resident GYR
Where
GYR_Month >= MonthStart(Today(), 5)
;
It was my bad.... forgot to add - next to 5
GYR_Month >= MonthStart(Today(), -5)
Thanks for the reply.
i tried this also, but getting same data,its not filtered in script.
GYR_Month >= MonthStart(Today(), -5)
How is GYR_Month read by qlikview? Is it able to recognize it as a date field or not?
GYR is Date field .
for example (i have changed the date to month)
GYR_Month
Mar 2018 1/03/2018
Do you have anything more going on except for this load?
LOAD Category,
val,
GYR_Month,
MonthName(GYR_Month) as GYR_Month1,
field1
Resident GYR
Where GYR_Month >= MonthStart(Today(), 5);
Are you dropping GYR after this load??