topic Re: freeze some fields not All !!! in QlikView

freeze some fields not All !!!

patrou38 — Wed, 29 Nov 2017 07:59:10 GMT

Hello, in the example attached, as you will see in my expression I put a '1' (=Sum({1} Amount)) to ignore all selections but how can do in my example to ignore all action in the 'Week' field but take into account actions in the 'Site' or 'People' field.

thank you for help and support.

Best regrds,

Patrick

Re: freeze some fields not All !!!

sunny_talwar — Wed, 29 Nov 2017 08:03:52 GMT

You should be able to do this to ignore selection in Week field....

Sum({<Week>} Amount)

Re: freeze some fields not All !!!

patrou38 — Wed, 29 Nov 2017 08:08:45 GMT

thank you for your answer Sunny,

But if I write something like = count({<Week>}Lot), all actions in all fields are impacted my result 😞

Re: freeze some fields not All !!!

sunny_talwar — Wed, 29 Nov 2017 08:10:07 GMT

All fields? Yes, Count({<Week>} Lot) is only ignoring selection in Week field... what other field is impacting selection which you don't want to impact selection?

Re: freeze some fields not All !!!

sunny_talwar — Wed, 29 Nov 2017 08:11:18 GMT

Alternatively, if you only want to allow selection in Site and People, you can try one of these

Sum({1<Site = $::Site, People $::People>} Amount)

Sum({1<Site = p(Site), People p(People)>} Amount)

Re: freeze some fields not All !!!

gys1992infosys — Wed, 29 Nov 2017 08:14:24 GMT

Hi Patrick,

For example: sum({<Field Name={''}>}Amount), it will be ignore the field name selection that the condition with underline.

Thanks,

Gary

Re: freeze some fields not All !!!

patrou38 — Wed, 29 Nov 2017 08:50:58 GMT

Great, it's work.

thank you to all !!!

Patrick

Re: freeze some fields not All !!!

gys1992infosys — Wed, 29 Nov 2017 09:10:57 GMT

Sorry, a mistake,correct is : sum({<Field Name= >}Amount), make the condition blank.