How to restrict dimension values in chart using if condition

[ramanarayan]

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

[PrashantSangle]

In expression try below,

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

dimension : Week_Year.

Note : avoid calculated dimension it is performance killer.

[tamilarasu]

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.

[sudhirpkuwar]

In Dimension limit tab select

[PrashantSangle]

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,