topic Re: How to show dimension value in App Development

How to show dimension value

ringolau — Mon, 20 Dec 2021 21:08:46 GMT

I have a [Month ID] as the filter in the chart and wants user to select a particular month. Then in the chart I want to use [Month ID] as the dimension and show the net sales of the last 12 months. As I only select one [Month ID] instead of a range, the chart can only show one month now. Any formula I can use in the dimension value to achieve what I want to do?

RIngo.

Re: How to show dimension value

kaushiknsolanki — Fri, 29 May 2020 14:00:51 GMT

Check this post.

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033

Re: How to show dimension value

dplr-rn — Fri, 29 May 2020 14:02:15 GMT

use set analysis something like below.

Sum( {<MonthYear={"<=$(=Max(MonthYear)) >=$(=Date(AddMonths(MonthYear,-12)))"}>} OrderRecordCounter)

Re: How to show dimension value

ringolau — Fri, 29 May 2020 14:17:49 GMT

Thanks for your answer but my issue is in how to show the dimension. Actually I am trying to use this expression for the chart dimension.

=if([Month ID] >= $(vSelectedMonthIDLY) and [Month ID]<=$(vSelectedMonthID),[Month ID] )

However as I only select one Month ID (YYYYMM) in the filter, it then dictate to show that mont in the x-axis only.