topic Re: Calculated Dimension in QlikView

Calculated Dimension

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

I have a bar chart with forecast information. The dimension is Year Month.

The users can select a Year and a Month from the selection boxes.

Now when a user selects 2020 Feb I would like my bar chart to show the selected YearMonth and three months in advance.

How can i modify the dimension that the chart will show Feb to May?

Regards,

Re: Calculated Dimension

martinpohl — Tue, 25 Feb 2020 15:03:49 GMT

here's an example:

Sum({<Date={">=$(=date(min(YearMonth)))<=$(=date(monthend(addmonths(min(YearMonth),3))))"}, YearMonth>} FC)

Date is the field in your datas.

YearMonth is a field from your calendar.

if the user can select Year and Month change to

Sum({<Date={">=$(=date(min(YearMonth)))<=$(=date(monthend(addmonths(min(YearMonth),3))))"}, Year,Month>} FC)

use it in expression, YearMonth as dimension

regards

Re: Calculated Dimension

Brett_Bleess — Thu, 26 Mar 2020 15:25:16 GMT

Wesley, did Martin's post get you what you needed? If so, please be sure to properly close out the thread by using the Accept as Solution button on Martin's post to mark it, this also gives him credit for the assistance and lets other Members know it did work. If you did something different, you can post that and mark it, but it is appreciated if you do close things out.

Regards,
Brett