topic Re: Re: Re: Edit show value in expression in QlikView

Edit show value in expression

Anonymous — Thu, 16 Oct 2014 11:35:32 GMT

Hi QVs,

I was trying to show only the values of a line chart which follow a condition, for example those that are in 2014. I edit the expression in show value with: =if(year(datefield)='2014', 1,0) but it doesn't work.

I found some discussions about it but i couldn't get a solution. Any idea?

Thanks for helping.

Marc.

Re: Edit show value in expression

tresB — Thu, 16 Oct 2014 11:39:59 GMT

Perhaps your date field is not properly formatted, use parsing fucntion date#() like:

=year(Date#(datefield, 'MMM YYYY'))=2014

Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 11:42:37 GMT

use like

If(Year[Datefield] = '2014',Expression,0)

Expression is like - sum(Sales)

Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 11:47:15 GMT

Field format is fine. Anyway i also tried with date# and date function, but no result.

Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 11:49:46 GMT

Basically that's what I typed. Changing the 1 by another expression doesnt give any result neither.

Re: Edit show value in expression

tresB — Thu, 16 Oct 2014 11:52:33 GMT

Could you post a sample qvw?

Re: Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 12:03:18 GMT

PFA.

Marc.

Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 12:14:27 GMT

The simple solution to your example file is:

=Count(IF(Year(FechaEncuesta)='2014',FechaEncuesta,NULL()))

I would recommend Set Analysis though.

Kind regards

Niklas

Re: Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 12:19:10 GMT

Niklas, the issue is not in the expression itself but in the 'show value' expression, explained in the initial post.

Thanks anyway.

Re: Re: Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 12:29:14 GMT

Well, put my formula in the Show Value box.

See attached example.

Kind regards

Niklas

Re: Edit show value in expression

tresB — Thu, 16 Oct 2014 12:33:31 GMT

Or, even simpler:

=Max(Year(FechaEncuesta)=2014)

Re: Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 12:46:11 GMT

Tresesco, you are definitely right. I was originally working more along the lines of the attached example.

Hence the full expression.

ONLY(Year(FechaEncuesta))=2013 is another alternative to MAX

Kind regards

Niklas

Re: Re: Edit show value in expression

Anonymous — Thu, 16 Oct 2014 14:25:38 GMT

Works fine. Thanks.