Show last 10 days in a bar chart

[#1]

Hi ,

I've been strugling to create an expression to show only the last 10 days on my chart .

this is how my data look like :

id_Date  2014 / S1     and  PDCH  90

              2014 / S2                       80

              2014/ S 3                        85

I wont to show only data of the current day and the 9 previous.

Any ideas Please.

Regards, Ameni

[robert_mika]

Yor Id_Date has only Year/Category how can you calculated date?

If you had numeric value you could use this method

Use a expression with an interval time using set analysis, something like this:

sum({<Id_date={">=$(vStartDate) <=$(vEndDate)"}>}PDCH)

where you declare two variables (in "Variables Overview") like this:

vEndDate = Max(MyDateField);

vStartDate = ($(vEndDate) -10);

[#3]

actually this is the Year/week_number  from master calender

[MK_QSL]

Provide proper sample data similar to you application.. This would help to work and answer..

[#5]

this is an exemple of my data where id_Date = Year / Week_number

[robert_mika]

If this is Year/Day how would you extract days?

Do you want to see last 10 values?

[#7]

Hi,

If id_Date is your dimension and you only want to show top 10 id_Dates, you could use expression:

=If(RowNo() < 11, yourexpression))

edit: 9 id_Dates to 10

[#8]

I want to show only the data for the last 10 days , is that possible ?

[ramoncova06]

I believe this should help

QlikView App: Dates, Date Ranges and Set Analysis

[danieloberbilli]

If your data is simple, you could sort the chart by expression and use there your date field with descending order. Then on the Dimension limits tab use Show only First 10 Values