Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total for specific dimension?

example.png

I want each column in this graph to have the same height - i.e. each column should add up to 100%. The problem is that the Total attribute counts every record for EVERY year, but I just want it to count the total for each year. Any suggestions on how to do this?

1 Solution

Accepted Solutions
julian_rodriguez

Hello Andy,

20140702.JPG.jpg

See the attachement, may be is what you need...

Regards,

View solution in original post

9 Replies
jerem1234
Specialist II
Specialist II

Try:

count([Const Type]) / (count(total <Year> [Const Type]))

Hope this helps!

Not applicable
Author

Nope, it still produces the same graph

julian_rodriguez

Hello Andy,

20140702.JPG.jpg

See the attachement, may be is what you need...

Regards,

View solution in original post

Not applicable
Author

I have to use Count instead of Sum like you used, but for some reason that still isn't working with my data set. You used the same method to Jeremiah recommended, but for some reasoning the <Year> modifier isn't doing anything on my data. Any idea what would cause this behavior?

Not applicable
Author

This is weird - I copy and pasted your graph into my QlikView and then modified the expression, and now it works! However, when I copy/paste the expression into my chart, it does not work. Do you know if there's a setting that could cause this?

julian_rodriguez

On the expressions tab, uncheck the "Relative" option... may be it is...

Not applicable
Author

Nope, that wasn't checked. I flipped through all of the tabs in the chart properties and couldn't find anything that seemed logical. This is certainly a mystery haha

jerem1234
Specialist II
Specialist II

I believe that you must have accidentally "detached" your chart (right click -> detach). When you do this, when you change the expression, the chart wont update the new change. If you then attach it again (right click -> attach), the changes to the expression should now work.

Not applicable
Author

It wasn't detached either, I checked for that too

When I create a graph from scratch I still get my original problem. I'm using QlikView 11.