topic Re: Derived Dimension in QlikView

Derived Dimension

kmmqlick — Mon, 25 Oct 2021 14:26:42 GMT

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

sergio0592 — Mon, 25 Oct 2021 15:19:58 GMT

Hi,

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

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

MarcoWedel — Tue, 26 Oct 2021 19:37:51 GMT

maybe helpful:

Marco