topic Expresion based on a selection in a field in QlikView

Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 20:03:40 GMT

Hi,

I have a bar chart with the following expression:

=sum({<[ Acquisition Date]={'2012'} >}[Current Total Expenses])

Anybody can help me figuring out why it is not giving me the results based on the 2012.

I have the Acquisition Date in a list box and if I select 2012 the chart gives me the right nrs but if I dont select anything then it show me all values from 2012-2011-2010.

Thxs,

Re: Expresion based on a selection in a field

MayilVahanan — Wed, 15 Aug 2012 20:11:44 GMT

Is [Acquisition Date ] is year field?

Re: Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 20:12:37 GMT

Yes, it has thre values:

2012

2011

2010

Thxs,

Re: Expresion based on a selection in a field

MayilVahanan — Wed, 15 Aug 2012 20:21:55 GMT

Can you post a sample? I don't know why not working..What are the dimension?

Re: Expresion based on a selection in a field

Anonymous — Wed, 15 Aug 2012 20:22:28 GMT

=use something in inline with below expression

Sum({$<Year={'2012'}>}Sales

Re: Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 20:24:18 GMT

It didn't work.

Thxs,

Re: Expresion based on a selection in a field

Anonymous — Wed, 15 Aug 2012 20:25:30 GMT

what is format (datatype)of acqusition date field ......?

Re: Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 20:33:31 GMT

The field in the excel file is like 10/23/2012

On loading the year I did :

year(Date(acqusition date)) as acqusition date

I have added this filed as a list box to my sheet. and created a table to show the dimenssion and [acqusition] date and [Current Total Expenses]. they all show in the right order.

but on the chart it is summing all values

Re: Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 20:34:00 GMT

I cannot post a sample.

The file is too big.

Thxs,

Re: Expresion based on a selection in a field

manojkvrajan — Wed, 15 Aug 2012 20:41:05 GMT

Set Analysis is not working and in addition $ symbol is missing in your expression. Did you try removing the quotes '' and enter the number directly? Please see if that works.

sum({$<[Acquisition Date]={2012} >}[Current Total Expenses])

Re: Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 20:47:33 GMT

I tried but it didn't work..

Not sure why!

thxs

Re: Expresion based on a selection in a field

manojkvrajan — Wed, 15 Aug 2012 21:05:10 GMT

Please upload a reduced qvw version and we can take it forward.

Re: Expresion based on a selection in a field

alec1982 — Wed, 15 Aug 2012 21:35:49 GMT

While trying to simplify a version to send it to you guys. I was able to figure it out.

The field that I was using is not the right one.

My bad.

Thanks so much for your help.

Alec