Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

12 Replies
Not applicable
Author

Hi Colin,

The two first options works! if I select the year 2012 show 2011. Third option does not work.

I think the problem is when I make the comparison of year....

If I replace the dimension year on the other, it works correctly.

count({$<ResultID={'FA'},TipoID = {'P1'}>}Id)

This brings me crazy !!  : )

Colin-Albert

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))

Not applicable
Author

Hi Colin,

Many , thank you very much. Yes, my field year is text, not a number. It Works perfetly.

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


The data source , including qlikview11 and sense was the same. But , looking at the load script , I saw that the year field was different.

Many Thanks for all the answers.