topic Re: Convert a Text Chart into a bar chart in QlikView

Convert a Text Chart into a bar chart

Nathan22 — Sat, 16 Nov 2024 18:27:36 GMT

Hi Guys,

I have a very basic question, i have done a calculation and represented it in text format with percent in the middle.for ex 77 % completed.

Just to make the graph visual i want to have a bar graph for same which have two bar graph one showing completed and other one showing total to be completed.

i can't create it as i dont have a dimension , can some body help me .

=num(count(distinct if([Rate Rectification]='Y' ,ACCOUNT_NO))
/count(distinct if([Rate Rectification]='Y' OR [Rate Rectification]='Pending' ,ACCOUNT_NO)), '#,##0%')

now from above calc i get 78 % can i show this as a bar graph filling up ? 78% green and 22 % red.

Re: Convert a Text Chart into a bar chart

Anonymous — Mon, 22 Jun 2020 11:15:28 GMT

If you need something like this, you need no dimension, put your expression in first expression, then define second expression as 1-first expression and define the numbers to be shown in percentage and define barchart design in staples
Or whatelse do you require?

Re: Convert a Text Chart into a bar chart

Nathan22 — Mon, 22 Jun 2020 11:29:50 GMT

thanks @Anonymous appreciate your help 🙂