Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am a beginner on QlikView .
I want to select a value in the field "Perc" which correspond to the "PC "field but which is not connected to the "AsOf" Field, that is why is think to put "1" parameters for the field AsOf.
I tried this Expression:
=SUM( {1<AsOf, PC = {"=$(=GetFieldSelections(PC))">} Perc)*100
Thank you in advance for your help,
Sébastien.
I think this in itself should be enough:
=SUM({<AsOf, PC = {"=$(=GetFieldSelections(PC))">} Perc)*100
Further simplify this like this:
If(GetSelectedCount(PC) > 0, Sum({<AsOf>} Perc) * 100)
Thanks you for your respons but even this expression doen't work:
=SUM( {<AsOf>} Perc)*100
I obtain 100 ok, but when i choose a item in the PC field, it doesn't work.
Because i set the Option "Always one valu selected" for the AsOf field:
Here "AsOf" is the "Date" field.
Here the Field Perc:
and the Selection Field:
Thanks in advance for your help,
Sébastien.
What about this?
=SUM( {<AsOf, Period>} Perc)*100
Thanks for your response, but it doesn't work too :/.
I think i can solve the problem with changing the database model
Ya, it seems like a data issue. Not sure why it won't work.
This is working?
=SUM({1} Perc)*100