Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
richard_chilvers
Valued Contributor

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
MVP

Re: Set analysis to ignore a dimension

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

Re: Set analysis to ignore a dimension

Hi,

try this.

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


Regards,

Kaushik Solanki

richard_chilvers
Valued Contributor

Re: Set analysis to ignore a dimension

Hi

Thanks for responding.

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

Re: Set analysis to ignore a dimension

Hi,

It does work for me in my app.

Can you share your application.

Regards,

Kaushik Solanki

Re: Set analysis to ignore a dimension

How about this?

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)

Re: Set analysis to ignore a dimension

May be you are looking for this

Below(Sum(Value), 12)

or better yet, use The As-Of Table

richard_chilvers
Valued Contributor

Re: Set analysis to ignore a dimension

This still produces zero values for 2017

richard_chilvers
Valued Contributor

Re: Set analysis to ignore a dimension

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.

Re: Set analysis to ignore a dimension

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?

richard_chilvers
Valued Contributor

Re: Set analysis to ignore a dimension

Hi Sunny

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