Expression works in QlikView 11, but does not work in Sense

[#1]

Hello,

I'm trying to create an expression that count the Id of my fact table with 2 conditions. This expression works in QlikView 11, but does not work in QlikView Sense.

=count( {$< Año= { $(#=Only(Año-1)) }, TipoID = {'P1'} > } Id )

Any explanation ? I do wrong ?

Thank you very much,

Javier

[Anonymous]

Just looking at your expression tells me that you dont have any '' round the expression for Año in the set analysis... maybe start there?

[Colin-Albert]

Try removing the #

count( {$< Año= { $(=Only(Año-1)) }, TipoID = {'P1'} > } Id )

[Anonymous]

Hello,

Can you share a .qvf or .qvw?

BR

Serhan

[#5]

Hi Serhan,

I'm not sharing , I'm just experimenting with Sense, to see if I can create a similar Dashboard.

Thanks,

Javier

[#6]

Hi Colin,

That does not work.

Thanks,

Javier

[#7]

Año (Year in english)  is a dimension. The I have a filtering panel.

[jagan]

Hi,

Try like this

=count( {$< [Año]= { $(#=Only([Año]-1)) }, TipoID = {'P1'} > } Id )

Only() should have one possible value, check whether [Año] has one possible value, otherwise Max() or Min() instead of Only().

Regards,

Jagan.

[#9]

Hi Jagan

Sorry, but not work.

Thanks,

Javier

[Colin-Albert]

Can you add a text object to check the value of

= $(#=Only([Año]-1))

or

= $(#=Only([Año]) -1)

and also try

= $(#=Max([Año]-1))

Only() will return Null if nothing or more than 1 value is selected.

Using Max() or Maxstring() instead is a safer option.