Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE

Set Axis labels number format independently from the measure

agilos_mla
Partner - Creator III
Partner - Creator III

Set Axis labels number format independently from the measure

Hello,

It should be nice if we could set the axis format independently from the format set in the expression. Currently axis labels for numbers inherit of the format set at the measure level (Auto, Number, custom ... and measure expression). 

But for instance, when i use a dual only to display values at the specific data points, especially with %, it works well in the chart area but the format on the axis is broken (see below I would have get 100.0%, 0.0%, -100.0% while in the expression I've written : 

dual(
if([OrderDate.autoCalendar.YearQuarter]= '2020-Q4', num( Sum(Sales)/above(Sum(Sales)) -1, '0.0%'), ' ')
, Sum(Sales)/above(Sum(Sales)) -1
)

Maybe even much better would be to have option for values on data points at first, last, min, max data points/bars as according to visualization standards then to avoid to use ugly expression like "duals" 😉

Axis labels format not aligned with measure expression.jpg

6 Comments
AndersLiu
Contributor
Contributor

I have the same question with you,would you have been fixed it,thank you.

AndersLiu_0-1624607599747.png

 

AndersLiu
Contributor
Contributor

My expression,
Dual
(
num( count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}
if(
aggr(
Count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Event_Speaker_Key)
,Speaker_ETMS_Code,Marketing_Campaign)=1
,Speaker_ETMS_Code)
)/
count(distinct {<Year_Month_Type={'Event End Date'},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={'N'},Event_Status={'Completed','Closeout Required'},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Speaker_ETMS_Code)
,'0.0%')
,
num(
count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}
if(
aggr(
Count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Event_Speaker_Key)
,Speaker_ETMS_Code,Marketing_Campaign)=1
,Speaker_ETMS_Code)
)/
count(distinct {<Year_Month_Type={'Event End Date'},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={'N'},Event_Status={'Completed','Closeout Required'},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Speaker_ETMS_Code)
,'0.0%')
)

Linda1
Partner - Contributor III
Partner - Contributor III

I support the idea that it would be possible to uncouple the measure format and the axis format in general.

For instance, it is interesting to see a value of 127,32€ as bar label or tooltip, but it is strange that axis labels are formatted like 25,00€/50,00€ etc. Why not make it 25€/50€ etc.? There is no value showing the two zero digits.

agilos_mla
Partner - Creator III
Partner - Creator III

Hey Linda, I overcome that issue by using a dummy measure that has the format without the decimal and put it first in the least of chart measures. It looks like QS is reading the format of the first measure to set the one on the axis then with the dual i succeeded to put the percentage with decimales on the line's last point 🙂  

agilos_mla_1-1636716089778.png

 

 

Linda1
Partner - Contributor III
Partner - Contributor III

Thank you very much for your tip! Could be very helpful now and then. But unfortunately, I don't see any way to get rid of the legend entry for that dummy measure (but to use CSS) 😕 which is no opportunity for some customers

Patric_Nordstrom
Employee
Employee

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.

Thanks, 
Patric

Status changed to: Open - Collecting Feedback