[ASK] how to show data at a particular days ?

[#1]

hello..

i want to show data in a particular days, how do i do that?

i know how to compare data for current year with year before current year

but now the client want to show data only in 5 days of range

so when he select the date, then the chart will show data for 5days till selected day

how can i do that with qlikview?

many thx...

[johnw]

Assuming you only need to do this when a single date has been selected, maybe a set like this?

{<Date={">$(=date(Date-5)) <=$(=Date)"}>}

You may need to ignore other fields in your calendar explicitly:

{<Date={">$(=date(Date-5)) <=$(=Date)"},Week=,Month=,Year=>}

[#3]

@John

hello John..

sorry i opened this forum just now

i've found an answer, it quite same with ur solution

in edit script for calendar table, i use this script :

Calendar:

LOAD

if(weekday(mst_date)<>'Sunday' and weekday(mst_date)<>'Saturday',mst_date) as mst_date,

if(weekday(mst_date)<>'Sunday' and weekday(mst_date)<>'Saturday',year(mst_date)) as year,

if(weekday(mst_date)<>'Sunday' and weekday(mst_date)<>'Saturday',month(mst_date)) as month,

if(weekday(mst_date)<>'Sunday' and weekday(mst_date)<>'Saturday',day(mst_date)) as date,

if(weekday(mst_date)<>'Sunday' and weekday(mst_date)<>'Saturday',weekday(mst_date)) as dayname

FROM

(qvd);

and for the expression for the cart i use this syntax :

Sum ({<dayname-={'Sunday',$(=if(dayname=6,1,9999))},mst_date={"<=$(=max(mst_date))>$(=date(max(mst-date)-6))"}>} (TRANS_IHSG_HIGH-TRANS_IHSG_LOW))

but the problem now,

if i select year-month-date, then it won't show data for the last 5days from the selected date

but if i select year-month-day(date), then it able to show data for the last 5days from the selected date

why is that happening?

thx..