topic Re: Restrict the months in dimension filter in App Development

Restrict the months in dimension filter

Prakash004 — Thu, 28 Jan 2021 10:18:58 GMT

Hi Experts,

Can any one please help me on below requirement.

I've data for 24 months but by default the user wants to see the data for 6 months and for the rest of the months he want's to see it using the filter.

I've s_month as the field.

@sunny_talwar @anil @Anil_Babu_Samineni @Kushal_Chawda @vaibhavv @anu @Sash

Re: Restrict the months in dimension filter

sonkumamon — Thu, 28 Jan 2021 15:13:32 GMT

Let me understand you further - in case of no user selection - you want the present the last 6 month. If the user select one month, you want to present only this month data, or the selected month + previous 5 month prior to it, or just the selected month alone?

Re: Restrict the months in dimension filter

Ksrinivasan — Thu, 28 Jan 2021 15:29:13 GMT

hi,

try this link

https://community.qlik.com/t5/Qlik-Sense-App-Development/QlikSense-Default-Month-Filter/td-p/1140625

ksrinivasan

Re: Restrict the months in dimension filter

Prakash004 — Thu, 28 Jan 2021 17:18:31 GMT

It should be just the selected month alone.

Re: Restrict the months in dimension filter

Prakash004 — Thu, 28 Jan 2021 17:22:43 GMT

Instead of writing the expression in every charts and KPI, is there any other work around?

Re: Restrict the months in dimension filter

sonkumamon — Thu, 28 Jan 2021 17:24:48 GMT

You can create a master measure and use it in all the charts an KPIs, thus you would need to write the expression only once.

Re: Restrict the months in dimension filter

Prakash004 — Thu, 28 Jan 2021 17:53:16 GMT

Hi Sonkumamon,

Could you please help me to write the expression please.

Let's assume the month field is 's_month' , and filed 'Sales' is the measure.

Thanks so much in advance.

Re: Restrict the months in dimension filter

Anil_Babu_Samineni — Fri, 29 Jan 2021 17:08:23 GMT

1) Create bookmark for selected one and it allows by default if you are using latest version in QS

2) Perhaps you can play around Only({<s_month = E(s_month)>}s_month)

Re: Restrict the months in dimension filter

Ksrinivasan — Fri, 29 Jan 2021 17:52:56 GMT

hi,

try this link

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Dimensions/calculated-dimensions.htm

ksrinivasan

Re: Restrict the months in dimension filter

sonkumamon — Fri, 29 Jan 2021 21:05:29 GMT

Hi Prakash,

Lets say you want to calculate the measure only for the selected month, then your expression should be something like this:

Sum({<s_month={$(=Max(s_month)}>} Sales)

Lets say you want to calculate the measure for the last 6 month when there is no selection, your expression should be like:

Sum({<s_month={">=AddMonths(Max(s_month),-6)<=Max(s_month)"}>} Sales)

So, if you want to make this expression dynamic (shows the last 6 month if no month is selected, and only the selected month in case of a selection, you should either use this 2 measures and each time hide one of then is concern of the selection, or create one dynamic measure:

Sum({<s_month=If(GetSelectedCount(s_month)=0,{">=AddMonths(Max(s_month),-6)<=Max(s_month)"},Max(s_month)) >} Sales)

Keep in mind that using the above expression may effect the performance as it uses an if expression for in a measure.

Uri