topic Re: Doubt in edit expression in QlikView

Doubt in edit expression

danialier — Tue, 14 Jan 2014 16:15:04 GMT

Hello !

In a List Box I have selected the year 2013. Then in a Text Box I want to see the previous yeat, so this is 2012. So when I select 2013 in the List Box I want the text box to show 2012.

Question: what should I put in the Edit Expression in the Text Box in order to get the 2012 ?

Thanks !

dani

Re: Doubt in edit expression

Anonymous — Tue, 14 Jan 2014 16:17:44 GMT

If you have Year selected, the expression is simple:

=Year-1

Re: Doubt in edit expression

atafsson — Tue, 14 Jan 2014 16:20:03 GMT

Hi,

If your field is named Year

and Year=2013

Type:

=sum(Year - 1)

Regards

Axel

Re: Doubt in edit expression

danialier — Tue, 14 Jan 2014 16:28:10 GMT

Hi Michael,

Actually the fornula I have is:

= num(sum({<REGION={'AMS'},VENDOR={'HP'},[Calendar Year]>}UNITS)/sum({<REGION={'AMS'},[Calendar Year]>}IDC_UNITS)*100,0.0)&'%'

What I want is that when selecting the year 2013 I need the formula to provide the inputs for the previous year, so 2012. What I'm missing in the formula ?

thanks !

dani

Re: Doubt in edit expression

Anonymous — Tue, 14 Jan 2014 16:34:07 GMT

Quite a different question 🙂

Use this

[Calendar Year]={"$(=[Calendar Year]-1)"}

instead of [Calendar Year]

Re: Doubt in edit expression

danialier — Tue, 14 Jan 2014 16:42:20 GMT

Excellent !!! that works now !!!! many Thanks Michael !!!!