topic Re: Set Expression Problem in QlikView

Set Expression Problem

Anonymous — Wed, 20 Apr 2016 11:37:18 GMT

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.

Re: Set Expression Problem

sunny_talwar — Wed, 20 Apr 2016 11:40:18 GMT

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)

Re: Set Expression Problem

Anonymous — Wed, 20 Apr 2016 11:48:16 GMT

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.

Re: Set Expression Problem

sunny_talwar — Wed, 20 Apr 2016 11:53:43 GMT

What about this?

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

Re: Set Expression Problem

Anonymous — Wed, 20 Apr 2016 12:02:28 GMT

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

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

Re: Set Expression Problem

sunny_talwar — Wed, 20 Apr 2016 12:15:52 GMT

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

Re: Set Expression Problem

sunny_talwar — Wed, 20 Apr 2016 12:28:36 GMT

This is working?

=SUM({1} Perc)*100