Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
In a bar chart of qliksense as below, the right side label number does't show the number in format correctly. the expressions in the measures are like following.
having also red other posts regarding similar issues earlier, and had changed the measure nubmer format like ¥#,##0K with remove same in the expressions, but it still returns same data 2.71K with the label, which should be 2.71M here.
How shall I correct this? thanks
num(Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GENGFEI'},Year,Quarter,Month,Week,Date={"$(='>='&Date(AddYears(YearStart(Max(Date),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max(Date),0), 'DD.MM.YYYY'))"}>}Order_Total_Value_Net_Local_Curreny)
/1000,'¥#,##0K;($#,##0K)')
How about changing +Ve values too?
num(Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GENGFEI'},Year,Quarter,Month,Week,Date={"$(='>='&Date(AddYears(YearStart(Max(Date),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max(Date),0), 'DD.MM.YYYY'))"}>}Order_Total_Value_Net_Local_Curreny)
/1000,'¥#,##0M;($#,##0M)')
If changes to M, then it has to be devided by 1000000 instead, then most of numbers would be quite small in decimal points.
however, in whatever case, the right side label chart seems unchangeable, with highest at 2.71k and smallest at 20.6
Good Question, In Qlikview we have option using Number tab
To use same feature in Qliksense, one way could be using this?
If(Len(Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GENGFEI'},Year,Quarter,Month,Week,Date={"$(='>='&Date(AddYears(YearStart(Max(Date),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max(Date),0), 'DD.MM.YYYY'))"}>}Order_Total_Value_Net_Local_Curreny))=4,
Num(Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GENGFEI'},Year,Quarter,Month,Week,Date={"$(='>='&Date(AddYears(YearStart(Max(Date),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max(Date),0), 'DD.MM.YYYY'))"}>}Order_Total_Value_Net_Local_Curreny)
/1000, '¥#,##0K;($#,##0K)'),
If(Len(Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GENGFEI'},Year,Quarter,Month,Week,Date={"$(='>='&Date(AddYears(YearStart(Max(Date),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max(Date),0), 'DD.MM.YYYY'))"}>}Order_Total_Value_Net_Local_Curreny))=7,
Num(Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GENGFEI'},Year,Quarter,Month,Week,Date={"$(='>='&Date(AddYears(YearStart(Max(Date),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max(Date),0), 'DD.MM.YYYY'))"}>}Order_Total_Value_Net_Local_Curreny)
/1000000, '¥#,##0M;($#,##0M)')))