topic Re: Dynamic Dimensions in QlikView

Dynamic Dimensions

kerkying — Wed, 25 Nov 2020 16:16:04 GMT

Hi, new to Qlikview here and I am trying to create a bar chart with a dynamic time dimension.

Behaviour of the chart should be like this:

When selecting "Monthly" in the Reporting Freq. field, the dimension will only show the current selection for Month and the previous 5 months.

When selecting "Quarterly", the dimension will only show the current selection for Quarter and the previous 3 quarters.

When selecting "Yearly" the dimension will only show the current year and the year before.

I was wondering if this can be acheived by using calculated dimensions and sets to limit the dimensions? Any help will be much appreciated, thanks!

beck_bakytbek — Thu, 18 Aug 2016 11:15:25 GMT

Hi Ying,

How does look your source table, if you Show your example then we can find appropriate solution for your issue

beck

marcus_sommer — Thu, 18 Aug 2016 11:30:18 GMT

I think you could do it with an expression like:

sum({< $(=only(FrequenzNum)) = {">=$(=max($(=only(FrequenzNum)))- $(=only(FrequenzNumParameter)))"}>} Value)

and a dimension like:

$(=only(FrequenzDim))

whereby FrequenzNum, FrequenzNumParameter and FrequenzDim belong to the same table like your listbox-field Reporting Freq. like this one:

table:

load * inline [

Reporting Freq., FrequenzNum, FrequenzNumParameter, FrequenzDim

Monthly, MonthNum, 5, YearMonth

Quarterly, QuarterNum, 3, Quarter

...

];

- Marcus