topic Re: creating a chart from an expression in QlikView

creating a chart from an expression

Mon, 11 Jul 2011 14:17:31 GMT

Hi I've managed to create a straigt table with some expressions to calculate the columns I need (all good)

I have something like this

where the Band is calculated as the following expression

=(Total>150,'Band F',IF(Total>60,'Band E',IF(Total>30,'Band D',IF(Total>10,'Band C',IF(Total>0,'Band B','Band A')))))

How do I know create a separate chart so I can count all the Band Bs and Band Cs

Its probably very simple but I can't seem to figure it out!

Thanks

nagaiank — Mon, 11 Jul 2011 14:43:57 GMT

Do you want to see something like what is in the attached qvw file?

Mon, 11 Jul 2011 19:20:07 GMT

Sorry I'm working with the Personal Edition, so I can't read your file

can you show me another way?

nagaiank — Mon, 11 Jul 2011 19:38:02 GMT

The details are in the attached word document.