topic Re: Expression to equal 2015 in QlikView

Expression to equal 2015

knightwriter — Mon, 27 Jul 2015 13:15:01 GMT

Hi all

I have the expression below and the answer I get is -1 and 0. I have a list of medals won by date and I want only the ones in 2015. Can you please help? And what is wrong with the below expression?

=year([Medal.Win Date])=2015

Re: Expression to equal 2015

sunny_talwar — Mon, 27 Jul 2015 13:16:49 GMT

May be this:

Dimension: Date

Expression: Count({<Year = {2015}>}[Medal.Win Date])

This should give you the count of medals on all dates.

HTH

Best,

Sunny

Re: Expression to equal 2015

Gysbert_Wassenaar — Mon, 27 Jul 2015 13:18:57 GMT

Your expression is a test. It tests if the result of year([Medal.Win Date]) is 2015. That test is either true (-1) or false (0). That's why you get -1 and 0 values.

Re: Expression to equal 2015

knightwriter — Mon, 27 Jul 2015 14:46:14 GMT

Hi Sunny,

Thanks for the suggestion, this works but I am looking for the column to show the year '2015' and for that column to show only 2015 data.

Thanks

Re: Expression to equal 2015

Gysbert_Wassenaar — Mon, 27 Jul 2015 14:49:19 GMT

Perhaps this expression does what you want: only({<[Medal.Win Date]={"=Year([Medal.Win Date])=2015"}>}[Medal.Win Date])

Re: Expression to equal 2015

sunny_talwar — Mon, 27 Jul 2015 14:50:01 GMT

Use expression Label as '2015'

Re: Expression to equal 2015

knightwriter — Wed, 29 Jul 2015 15:50:04 GMT

Hi Sunny,

Thanks for the response. I dont actually want to change the Column title but to have the column contents show the year 2015 in the cells rather than 1 etc.

I have this sorted thanks to the above expression. Thanks again for your help.