Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Nathan22
Contributor II
Contributor II

Convert a Text Chart into a bar chart

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.

 

 

1 Solution

Accepted Solutions
Anonymous
Not applicable

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?

hrlinder_0-1592824234364.png

 

 

View solution in original post

2 Replies
Anonymous
Not applicable

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?

hrlinder_0-1592824234364.png

 

 

Nathan22
Contributor II
Contributor II
Author

thanks @Anonymous  appreciate your help 🙂