topic Re: P function with multiple fields in QlikView

P function with multiple fields

19iv1987 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I need to keep fixed a calculation in a textbox for all filters except for three filters.

I already used P function but it seems not working with multiple fields.

Anyone can help me?

Thanks in advance

Eva

sunny_talwar — Tue, 07 Feb 2017 13:52:51 GMT

Try with $:: may be

Sum({<Field1 = $::Field1, Field2 = $::Field2, Field3 = $::Field3>}Measure)

Anil_Babu_Samineni — Tue, 07 Feb 2017 13:53:54 GMT

I would love to go (P) option, But unfortunately it won't

Other approach could be using {1}

Like(Added one on that, It will give constant value for you)

Count({1<Month = :: Month, Year = ::Year >}Sales)

Anonymous — Tue, 07 Feb 2017 13:57:29 GMT

Hi Eva,

Can you share the expression? What do you mean by keeping fixed? To not take in consideration the selection of the fields?

Have you tried:

sum({Customer=,Year=,Month=} Sales). this will give you the sales, no matter what Customer, Year, Month you select.

If this is the case, you can put in the set analysis the fields fixed with "=", except for three filters.

Best regards,

Cosmina

19iv1987 — Tue, 07 Feb 2017 13:58:19 GMT

Hi Sunny,

It seems not working, maybe it needs 1 somewhere..

sunny_talwar — Tue, 07 Feb 2017 13:59:46 GMT

Hahahaha yes

Sum({1<Field1 = $::Field1, Field2 = $::Field2, Field3 = $::Field3>}Measure)

19iv1987 — Tue, 07 Feb 2017 14:04:52 GMT

Sunny with 1 at the beginning it works!thanks a lot

19iv1987 — Tue, 07 Feb 2017 14:06:01 GMT

Hi Cosmina, thanks for the answer but I have to much fields to lock so your method it's quite expensive for me

sunny_talwar — Tue, 07 Feb 2017 14:51:48 GMT

Super cool