Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Calculated Dimension

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,

W

2 Replies
Highlighted
Partner
Partner

Re: Calculated Dimension

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

Highlighted
Digital Support
Digital Support

Re: Calculated Dimension

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.