Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

 

 

View solution in original post

Nathan22
Contributor II
Contributor II
Author

thanks @Anonymous  appreciate your help 🙂