topic Re: Display Expression as % and counts as values on data point in QlikView

Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 03:12:55 GMT

Hi all

Can someone please help me with my chart? Below is a screen shot of my chart which basically displays correctly except that I want the dimension Axes to show as a percentage. I have added a screenshot further below of how it looks in Word.

If you look at the Word version and we look at site wickham the chart tells us that 26 of their requisitions were required in 2-6 days which equates to just under 40% and they also had 27 of their requisitions were required in 0-1 days and the percentage of that was just over 40%

I hope my request makes some sense. Any help would be greatly appreciated.

Re: Display Expression as % and counts as values on data point

sujeetsingh — Thu, 03 Apr 2014 03:29:51 GMT

post your sample and please explain what you want

Re: Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 03:45:10 GMT

Hi,

Create a bar chart with two expression:

One for Count
Second for %

For count expression, unckech "Bar" under "Display Option" and check "Value on data point" on expression Tab.

Hope it help you.

Regards

Ankur

Re: Re: Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 04:00:17 GMT

Hello

I have attached qvw file. Basically I want the axis data to show like the word version of the chart.

cheers

Re: Display Expression as % and counts as values on data point

sujeetsingh — Thu, 03 Apr 2014 04:08:39 GMT

see this

Re: Re: Re: Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 04:08:44 GMT

Please find attached

Re: Display Expression as % and counts as values on data point

sujeetsingh — Thu, 03 Apr 2014 04:13:27 GMT

Chris,

Avoid posting your qvw with original data in it .

It to be always avoided.

To get out of this just do one thing create a sample file either by INLINE table or just export a section of data in in excel

and then reload the file with the excel file with hiding information like ID ,Name ,Account details etc

Re: Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 04:37:23 GMT

Thanks for this. When selecting one site only I get the exact data I require. But when selecting more that one site it reduces the percentage. MIKAR is showing in the first screen shot as having over 50% in the o-1 Day range however when all sites are displayed the 50% becomes about 17%. Each site needs to add up to 100% not 100% across all sites. Hope that makes sense?

Re: Re: Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 05:02:28 GMT

Please find attached......and plaese reply to correct comment so that other can find the same

Re: Re: Display Expression as % and counts as values on data point

Thu, 03 Apr 2014 05:04:47 GMT

Brilliant. Thankyou so much.