Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 !! : )
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))
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.