Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

1 Solution

Accepted Solutions

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

If the 3rd expression fails then try this in a text box to test if your Ano field is text not a number

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

12 Replies
apalmtree
Contributor

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

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?

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

Try removing the #

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

darkhorse
Valued Contributor

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

Hello,

Can you share a .qvf or .qvw?

BR

Serhan

Not applicable

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

Hi Serhan,

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

Thanks,

Javier

Not applicable

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

Hi Colin,

That does not work.

Thanks,

Javier

Not applicable

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

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

MVP
MVP

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

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.

Not applicable

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

Hi Jagan

Sorry, but not work.

Thanks,

Javier

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

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.

Community Browser