topic Re: Issue with Line chart label in App Development

Issue with Line chart label

rathnam_qv — Mon, 08 May 2017 18:17:02 GMT

Hi All,

i have a line chart and i have applied color by measure.

The problem is i am seeing the condition as label and two labels are displaying.

How to restrict it to display a single label instead of the actual condition.

PFA screen shot.

Thanks,

Rathnam.

Re: Issue with Line chart label

Anonymous — Wed, 10 May 2017 17:42:39 GMT

Hi Rathnam,

Did you try going to Data --> Measures and add a value to the "label"? Whatever you enter here will be displayed instead of the actual formula.

Happy Qlik-ing!

Re: Issue with Line chart label

rathnam_qv — Fri, 12 May 2017 09:40:48 GMT

Hi Ashwin,

Thanks for your reply.

i have given label name to measure.You can see "Sales" label. The formula is displaying because after applying color by measure.

Thanks,

Muni.

Re: Issue with Line chart label

Anonymous — Mon, 15 May 2017 16:40:03 GMT

Can you show me your dimension, measure and color values?

Thanks

Re: Issue with Line chart label

rathnam_qv — Mon, 22 May 2017 11:12:21 GMT

Hi Ashwin,

sorry for late response.

PFB

Dimension:

IF(daystart(time_period_date) - daystart(NOW()) < 0 ,'(A)Past Due'

,IF(daystart(time_period_date) - daystart(NOW()) >= 0 AND relative_global_quarter = 0 ,fiscal_month_mmm

,IF(daystart(time_period_date) - daystart(NOW()) >= 0 AND relative_global_quarter = 1 ,fiscal_quarter_desc

,IF(daystart(time_period_date) - daystart(NOW()) >= 0 AND relative_global_quarter = 2 ,fiscal_quarter_desc

))))

Measure:

IF(GetFieldSelections(View_Currency)='USD',

IF(GetFieldSelections(category)='CRD'

,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,crd_nsb)),'$#,##0;($#,##0)')

,IF(GetFieldSelections(category)='OPD'

,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,opd_nsb)),'$#,##0;($#,##0)')

,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,ssd_nsb)),'$#,##0;($#,##0)')

)

IF(GetFieldSelections(View_Currency)='EUR',

IF(GetFieldSelections(category)='CRD'

,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,crd_nsb_eur)),'€#,##0;(€#,##0)')

,IF(GetFieldSelections(category)='OPD'

,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,opd_nsb_eur)),'€#,##0;(€#,##0)')

,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,ssd_nsb_eur)),'€#,##0;(€#,##0)')

)

))

Color: i am applying by measure.

Thanks