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
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))
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?
Try removing the #
count( {$< Año= { $(=Only(Año-1)) }, TipoID = {'P1'} > } Id )
Hello,
Can you share a .qvf or .qvw?
BR
Serhan
Hi Serhan,
I'm not sharing , I'm just experimenting with Sense, to see if I can create a similar Dashboard.
Thanks,
Javier
Hi Colin,
That does not work.
Thanks,
Javier
Año (Year in english) is a dimension. The I have a filtering panel.
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.
Hi Jagan
Sorry, but not work.
Thanks,
Javier
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.