topic Re: How to remove current year line value on data point ? in QlikView

How to remove current year line value on data point ?

Fri, 07 Mar 2014 14:10:30 GMT

Hi All

My chart only have 1 expression. and it display 2013 sales trend and 2014 sales trend.

I only want 2013 sales value display at data point , how to do it ?

Re: How to remove current year line value on data point ?

Fri, 07 Mar 2014 14:12:46 GMT

Hi All

enclosed my QV doc

Re: How to remove current year line value on data point ?

MK_QSL — Fri, 07 Mar 2014 14:15:44 GMT

Go to expression

CLick on +

under Show Value write below expression

year = 2013

Re: How to remove current year line value on data point ?

Anonymous — Fri, 07 Mar 2014 14:15:49 GMT

Try this expression.

money(

Sum(

{<Year={'2013'}>}

sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

Re: How to remove current year line value on data point ?

Gysbert_Wassenaar — Fri, 07 Mar 2014 14:16:14 GMT

Click on the + in front of the expression, choose Text Color and enter as Definition this expression: if(year=2013,white(0),black())

Or this one: if(year=2014,black(),white(0))

Re: How to remove current year line value on data point ?

Mon, 10 Mar 2014 02:42:53 GMT

Hi All

Thank you for all your reply. it work fine now. I hv follow up question , may i know how to make the line color as my wish , for example 2014 red and 2013 gray. of cos i can change to any other color i need in future.

Paul

Re: How to remove current year line value on data point ?

Gysbert_Wassenaar — Mon, 10 Mar 2014 10:15:49 GMT

Click on the + in front of the expression, choose BackgroundColor and enter as Definition =if(year=2014,red(), if(year=2013, lightgray())) or use lightred() for reds and for example rgb(150,150,150) for grays.

Re: How to remove current year line value on data point ?

Mon, 10 Mar 2014 13:55:27 GMT

Hi Sir

if(year=2014,lightgray(1),black())

I try above , because i want 2014 lightgray and 2013 black

but not working. pls help.

Re: How to remove current year line value on data point ?

Gysbert_Wassenaar — Mon, 10 Mar 2014 16:34:12 GMT

lightgray(1) will give the lightgray color an alpha value of 1, which will make it almost 100% transparent. Try just if(year=2014,lightgray(),black())

Re: How to remove current year line value on data point ?

Tue, 11 Mar 2014 01:48:58 GMT

Hi Sir

For with out maintenance , i need to use year equal current year expression below :-

<Year={'>$(=year(today())-0)'}>

I assume below code should do the work , but cannot work :-

if(<Year={'>$(=year(today())-0)'}>,lightgray(),black())

Can advise me ?

Re: How to remove current year line value on data point ?

jagan — Tue, 11 Mar 2014 03:16:38 GMT

Hi Paul,

Try like this

<Year={$(=year(today()))}>

Regards,

Jagan.

Re: How to remove current year line value on data point ?

Tue, 11 Mar 2014 03:44:41 GMT

Hi Mohan

if(<Year={$(=year(today()))}>,lightgray(),yellow())

I try the above expression it still not work.

Paul

Re: How to remove current year line value on data point ?

jagan — Tue, 11 Mar 2014 04:03:19 GMT

Hi,

Then try like this

if(<Year=year(today()), lightgray(),yellow())

Make sure that Year and Year(Today()) values are in same format, i.e,

For example : 2014 in Year field and Year(Today()) = 2014

Regards,

jagan.

Re: How to remove current year line value on data point ?

Tue, 11 Mar 2014 04:56:56 GMT

Hi Mohan

Thank you very much. but today i no luck . will try again other day.