Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
matthewlau120
New Contributor

100% Stack Column Chart Display Issue

Hi All,

 

I have a question about the display of the 100% stack column chart. Why would the entity  "FW" shown in 100% but the x axis still have 150% ? In Alternative, I have choose another entity "HC" shown in 100% but don't have this issue.

Kindly attach for the screenshot and set analysis equation:

Equation: (Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}Productnetamount)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}[sales_details.disc_amt])
-Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}amt)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}cdisc_amt)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]-={"PREPAID_****"}>}[sales_details.disc_amt])
+Sum({$-<[check_time.autoCalendar.Date]={'$(=date(max([check_time])))'},[sales_details.status]={"0"},[sales_details.item_code]={"*"}>}[sales_details.disc_amt]))
/(Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}Productnetamount)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}[sales_details.disc_amt])
-Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}amt)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}cdisc_amt)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]-={"PREPAID_****"}>}[sales_details.disc_amt])
+Sum(total<Day>{$-<[check_time.autoCalendar.Date]={'$(=date(max([check_time])))'},[sales_details.status]={"0"},[sales_details.item_code]={"*"}>}[sales_details.disc_amt]))

 

Screenshot (HC)

Screenshot 2019-03-11 at 6.04.41 PM.png

fwScreenshot 2019-03-11 at 6.04.28 PM.png