topic Re: Display 2 expressions values inside 1 bar in QlikView

Display 2 expressions values inside 1 bar

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlikview Experts,

Recently I had received a request from one of my clients to improve the functionality of a bar chart by displaying 2 expression values inside 1 single bar. I was wondering if this is possible to achieve in Qlikview?

Basically right now the bar chart is displaying the % of Goods in a field. On the other hand, clients also want to see the total number of counts for that field to be displayed inside the bar. (The request from the client has been highlighted in RED at the picture below)

I had attached the sample Qlikview file for your reference.

I have no idea whether this is able to achieve in Qlikview, but any ideas from you all would be greatly appreciated!

Best Regards,

QianNing

Re: Display 2 expressions values inside 1 bar

trdandamudi — Sun, 07 Jan 2018 12:27:19 GMT

One way you can do is, showing the count and percentage in the brackets on the top of the bar. Take a look at the attached file and hope this helps.

Re: Display 2 expressions values inside 1 bar

Anil_Babu_Samineni — Sun, 07 Jan 2018 12:36:39 GMT

What is the measure for second data points to get 20, 38, 52?? Is this okay?

Re: Display 2 expressions values inside 1 bar

s10157754 — Sun, 07 Jan 2018 12:49:15 GMT

Dear Thirumala,

Your ideas looks good and I am willing to take into consideration. May I know more details on how you achieve this outcome? As I was using the Personal Edition, So I am not able to open your qlikview file. Appreciate if you can guide me step by step on how you achieved this outcome. Thanks for your help in advance!

Best Regards,

QianNing

Re: Display 2 expressions values inside 1 bar

s10157754 — Sun, 07 Jan 2018 12:51:13 GMT

Dear Anil,

Your solution looks awesome as well. The measure for second data points will be "count(Result)". As I was using Personal Edition, are you able to provide more with more details on how you did this?

Best Regards,

QianNing

Re: Display 2 expressions values inside 1 bar

trdandamudi — Sun, 07 Jan 2018 13:02:57 GMT

keep your existing expression and uncheck "Values on Data Points" for that expression. Now add one more expression as below:

count({<[Result] = {'Good'}>}[Result]) &'(' &Num(count({<[Result] = {'Good'}>}[Result]) /

count(Result),'#0.%') &')'

make sure you remove the check against bar in "Display options" as show below:

Re: Display 2 expressions values inside 1 bar

Anil_Babu_Samineni — Sun, 07 Jan 2018 13:14:06 GMT

But, Count(Result) returns all 9's only. Anyway i pick Combo chart and attached images for you. Then, Give Dynamic Scale to achieve and one thing we need to know the second expression position should be Right

Re: Display 2 expressions values inside 1 bar

s10157754 — Sun, 07 Jan 2018 13:43:57 GMT

Dear Anil,

I had follow your guides through the picture but still unable to achieve the same outcome as you. Did I miss out anything?

Best Regards,

QianNing

Re: Display 2 expressions values inside 1 bar

Anil_Babu_Samineni — Sun, 07 Jan 2018 15:05:05 GMT

Go to axis tab and select Expressions and enable static min/max from scale section

Same for second, But including Position is right

Re: Display 2 expressions values inside 1 bar

s10157754 — Mon, 08 Jan 2018 00:11:14 GMT

‌Dear Thirumala,

Thanks so much for your solution. I think your idea is more closer to the requirement from the client. Appreciated so much for your kind effort!

Best Regards

QianNing