Graph drill down with expressions

[#1]

Hi everyone, I am new here 🙂

I have been playing with Qlikview for a few weeks now but have ran into a problem when creating bar charts. I can only drill down one level (needs to be two), if I use expressions that use an IF statement. e.g. =Count(IF (Rating = 'Green',Rating)) or =Count(IF (Rating = 'Amber',Rating)) etc etc.

How can I rewrite the expression or change a setting to fix this? Or am I just totally missing the point 🙂

My table structure is as follows (just test data):

SAMPLEDATA:
LOAD * INLINE [
Country, Department, Rating
UK, IT, Critical
USA, Finance, Amber
Canada, HR, Red
France, Commercial, Green
France, Commercial, Green
France, HR, Green
France, HR, Amber
France, IT, Red
France, Commercial, Red
France, Commercial, Red
];

Many thanks,

Matt

[amars]

Hi Matt, If I have understood ur problem , u need to show the count for "Amber" and "Green". You can write a single expression like =Count(IF (Rating = 'Green' or Rating='Amber',Rating)) . Thanks

[#3]

amars thanks for your reply 🙂

I have attached a demo qlikview of my problem. If for exmaple on the chart you select 'HR' you can see Red, Amber and Green but if you select anyone of those three it takes you back to the full view of the graph and doesn't drill down. Does that make sense?

[View:http://fullbhp.com/news/admin/graph_drill.qvw:550:0]

Thanks,

Matt

[#4 · Accepted solution]

Hi Dude,

I have added new chart.I hope It will work.If you have any query let me know the same.

Thanks & Regards

Jai

[#5]

Jai,

Thats exactly what I was after 🙂 Just got my head around using groups so I can do it myself but with proper data.

Many thanks for your help!!

Matt