Chart suggestion

[rxp03570]

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,

[lironbaram]

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]

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]

Should use a Pivot Table.

[rxp03570]

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]

Rahul,

Try with Qlik's Insights.

Looks like a candidate for stackable bar chart?

Can you share some sample data?

[raman_rastogi]

Hi Rahul

You can try Bar chart without dimension.

to make this you have to make 10 expressions.

Regards

Raman