topic Help me with expression using Possible function ? in QlikView

Help me with expression using Possible function ?

ashmitp869 — Tue, 18 Jan 2022 02:34:35 GMT

Hi there,

Please kindly assist to write a expression -

to show all the possible data

i.e show data for all the [Service Unit Code] and [Provider Type Code] for that NTNAME selection irespective of _sokey

sum( {$<_sokey=,[Service Unit Code] = P({1<NTNAME=OSUSER()>}[Service Unit Code]),[Provider Type Code] = P({1<NTNAME=OSUSER()>}[Service Unit Code])>} _active_flag)

I am trying to use the above expression but giving error

Re: Help me with expression using Possible function ?

marcus_sommer — Tue, 18 Jan 2022 08:48:57 GMT

There is a syntax issue with ossuser(). I think it needs to be look like:

sum( {$<_sokey=,
[Service Unit Code] = P({1<NTNAME={'$(=OSUSER())'}>}[Service Unit Code]),
[Provider Type Code] = P({1<NTNAME={'$(=OSUSER())'}>}[Service Unit Code])>} _active_flag)

Beside this I'm not sure if NTNAME is available if it's a part of a section access. If section access is in use it may be more suitable to apply it also for this kind of view.

- Marcus