# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Specialist

## Set analysis to ignore a dimension

I have a chart table like this :

YearMonthValueLast Year's Total Value
2017Dec1000
2017Nov1200
2017Oct1500
2017Sep2000
....etc.
2016Dec1201,250
2016Nov801,250
2016Oct1501,250
2016Sep901,250
etc.....

In the last column, I would like always to have the total value for 2016, but for Year=2017, the column has zeroes.

I am using the expression:

SUM( {1 <Year = {'2016'} > } Value)

So the expression is being affected by the Year dimension. How do I ignore this dimension?

Thanks.

1 Solution

Accepted Solutions
MVP

What do you see if you put

=SUM( {1 <Year = {'2016'} > } Value)

in a text box?

You should see this value also in the least granular partial sum row in your table chart.

If you do, then Kaushik's expression using the TOTAL qualifier should work.

If not, then please post a sample QVW.

12 Replies

Hi,

try this.

SUM( {1 <Year = {'2016'} > } total Value)

Regards,

Kaushik Solanki

Regards,
Kaushik
Specialist
Author

Hi

Thanks for responding.

Your expression gives me the total for both years (ie. 2016 + 2017). Seems to ignore the set analysis.

Hi,

It does work for me in my app.

Regards,

Kaushik Solanki

Regards,
Kaushik

Alt(Sum(TOTAL <Year>  {<Year={2016}>} Value),0)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

May be you are looking for this

Below(Sum(Value), 12)

or better yet, use The As-Of Table

Specialist
Author

This still produces zero values for 2017

Specialist
Author

Hi Sunny

Thanks as always for your response. I can see that both your suggestions will probably work, although I haven't tried them.

I felt my expression should work and was hoping that someone would correct an error. I must not understand the purpose of {1} in a set analysis.

MVP

Would be able to point out what your desired output is/was? What you have posted above is what you are getting, but what do you need?

Specialist
Author

Hi Sunny

I need the total value for 2016 (ie. 1,250) to appear in the last column of every row.