Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
komminenianusha
Partner - Contributor III
Partner - Contributor III

Bar chart Percentage

Hi All,

I am working on qlikview to qliksense migration . In qlikview used trellis pie chart with 2 dimensions(1 dimension is Drill down and other is normal dimension) and 1 expression  .

Please find qlikview chart in below image

Capture.PNG

In qlikview expression is like     sum(sales)/sum(total <Drilldown Dimension>sales)

In Qliksense I am using Bar chart because pie chart is not supporting 2 dimensions but I am facing issue with % values.Capture.PNG

Instead of drilldown dimension what we can use in qliksense because qliksense won't support drill down .

Please any one help me on this.This is very urgent

 

Regards,

Anusha

 

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

The latest release of QlikSense (Feb 2018) comes with 2 optional extensions bundles. One of the extensions is the multi-KPI (something like that), which operates like a trellis, but only for KPIs. If you search  QlikBranch you may be able to find a proper trellis extension, like this

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

or

https://developer.qlik.com/garden/5718fb1d80955830cdd6e7fb

 

I have not tried them myself and offer no guarantee that they will work correctly.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
komminenianusha
Partner - Contributor III
Partner - Contributor III
Author

Not allowed to use any extensions. So, I want percentage values on bar chart .