topic Re: How to removes values from dimension(Calculated Dimension) in QlikView

How to removes values from dimension(Calculated Dimension)

Wed, 25 Nov 2020 16:16:04 GMT

Hello Community,

Here I have some problem in my pivot table dimension.

I want to remove last n months form sale month dimension in pivot table

If months are more than 12 ,so Sale Year should be remove.

please find attach image for more clarity.

thanks in advance.

Regards

R.Kumar

sunny_talwar — Wed, 07 Sep 2016 17:42:38 GMT

What exactly are you trying to remove? Can you elaborate what the result needs to look like?

Thu, 08 Sep 2016 06:19:54 GMT

hi sunny ,

sorry I attached wrong attachment ,

in my pivot table I am showing sell out where I want to remove n sale months sale out details from pivot table.

ex- I have one filter MIS have values 3,6,12 and 24

If I select 3 in MIS last three sale (From Current month) months Sell out should not come.

Regards

R.Kumar

Anonymous — Thu, 08 Sep 2016 19:39:16 GMT

Hello Raman,

Try this:

sum({<nData={'>=$(=num(addmonths(Today(),-$(MIS))))<=$(=num(Today()))'}>}Expression1)

nData = numeric date

Mon, 12 Sep 2016 11:53:32 GMT

thanks Fernando,

This expression really helpful to make right one.