Derived Dimension

[kmmqlick]

Hi All,

I am having 2 fields Week and sales, I am taking a bar chart using these 'Week' dimension and Sum(Sales) as Measure.

I am having Week Filter.

if user choose particular week in the filter chart needs start from that week.

example axis Week1-Week10 showing sales values. when user selected Week5 , bar chart need to show Week5-Week10 only.

Plz tell me how to write expression

WeeK	Sales
Week1	10
Week2	20
Week3	30
Week4	40
Week5	50
Week6	60
Week7	70
Week8	80
Week9	90

[sergio0592]

Hi,

It works with the following expression if you remove 'Week' from the value (keep only numeric part):

sum({<Week={">=$(=Week)"}>}Sales)

[MarcoWedel]

maybe helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Marco