topic Graph drill down with expressions in QlikView

Graph drill down with expressions

Fri, 07 Jan 2011 11:36:46 GMT

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

Graph drill down with expressions

amars — Fri, 07 Jan 2011 12:40:25 GMT

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

Graph drill down with expressions

Fri, 07 Jan 2011 12:53:39 GMT

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

Graph drill down with expressions

Fri, 07 Jan 2011 13:44:03 GMT

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

Graph drill down with expressions

Fri, 07 Jan 2011 15:54:35 GMT

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