topic How to restrict dimension values in chart using if condition in QlikView

How to restrict dimension values in chart using if condition

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

H Experts,

In the attached qvw, i need to show the latest 4 weeks in my dimension. Please advise.

I need to able to see only the following weeks in my chart

201821

201820

201819

201818

Thanks,

Ram

Re: How to restrict dimension values in chart using if condition

PrashantSangle — Mon, 28 May 2018 07:51:39 GMT

In expression try below,

=sum({<Week_Year={'201821','201820','201819','201818'}>}Amount)

dimension : Week_Year.

Note : avoid calculated dimension it is performance killer.

Re: How to restrict dimension values in chart using if condition

tamilarasu — Mon, 28 May 2018 07:52:36 GMT

Hi,

Have a look at the attached file. I would suggest you to use set expression as calculated dimension is not necessary in this case and it will impact the performance when you have large data.

Re: How to restrict dimension values in chart using if condition

sudhirpkuwar — Mon, 28 May 2018 07:52:48 GMT

In Dimension limit tab select

Re: How to restrict dimension values in chart using if condition

PrashantSangle — Mon, 28 May 2018 07:53:40 GMT

If you still want it in calculated dimension then try

if(match(Week_Year,'201821','201820','201819','201818'),Week_Year)

and select suppress when value is null

Regards,