Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rxp03570
Creator
Creator

Chart suggestion

Hi All,

I do have a requirement where I have to show Count(Accounts) as measure and do have Product_Status1, Product_Status2,Product_Status3,Product_Status4 and Product_Status5 where Product_statuses have field value "Completed" and "Not-Completed" . I have to show a visualization with Number of accounts which are completed and Not-Completed for these five product statuses.

Any idea on how this can be done?.

Thanks,

6 Replies
lironbaram
Partner
Partner

hi

is there any connection between the statuses so you want to see the flow between statuses

if this is the cases i would have considered using sankey diagram

https://developer.qlik.com/garden/5a625aff68f1e798e4ceb107

rxp03570
Creator
Creator
Author

There would be no connection between the statuses, we just have to display how many of these account fall under completed and Not-Completed for all the 5 Products_Statuses.

Thanks for your reply 🙂

CathyRDuvall
Contributor III
Contributor III

Should use a Pivot Table.

rxp03570
Creator
Creator
Author

Thanks for the reply Cathy, I did have the same idea - but the business wants to have a visualization for this one. Any idea on how this can be shown visually?.

nsetty
Partner
Partner

Rahul,

Try with Qlik's Insights.

Looks like a candidate for stackable bar chart?

Can you share some sample data?

raman_rastogi
Partner
Partner

Hi Rahul

You can try Bar chart without dimension.

to make this you have to make 10 expressions.

Regards

Raman