Set Expression Problem

[Anonymous]

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.

[sunny_talwar]

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)

[Anonymous]

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.

[sunny_talwar]

What about this?

=SUM( {<AsOf, Period>} Perc)*100

[Anonymous]

Thanks for your response, but it doesn't work too :/.

I think i can solve the problem with changing the database model

[sunny_talwar]

Ya, it seems like a data issue. Not sure why it won't work.

[sunny_talwar]

This is working?

=SUM({1} Perc)*100