Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewlau120
Contributor
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

0 Replies