Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to removes values from dimension(Calculated Dimension)

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

1 Solution

Accepted Solutions
fernando_vizcai
Contributor III
Contributor III

Hello Raman,

Try this:

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

nData = numeric date

View solution in original post

4 Replies
sunny_talwar

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

Not applicable
Author

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

fernando_vizcai
Contributor III
Contributor III

Hello Raman,

Try this:

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

nData = numeric date

Not applicable
Author

thanks Fernando,

This expression really helpful to make right one.