topic Re: Notification when selection is excluded in QlikView

Notification when selection is excluded

daniel_f — Mon, 09 Jul 2012 12:47:28 GMT

hi all,

I need to know if is possible to get a notification (using the object conditional show) when a specifically selection is excluded. Something like 'GetFieldSelections' but when a user decide to exclude something.

For example:

I made a text with the message "For your information, blah, blah ..." And I want to show it in a text box when the user has chosen not to include (exclude) a specific customer from the list of customers (dimension)

Is this scenario possible to create standard? i use Qlikview 11.

thanks in advance,

Daniel

Re: Notification when selection is excluded

swuehl — Mon, 09 Jul 2012 13:03:57 GMT

Should be possible using the conditional show in layout tab, something like

if(GetSelectedCount(FIELD) and not WildMatch(concat(FIELD),'*C*'),1,0)

Re: Notification when selection is excluded

Mon, 09 Jul 2012 22:34:15 GMT

conditional show

=count( {<Customer={"Specific customer"}>} Customer) = 0

Re: Notification when selection is excluded

daniel_f — Tue, 10 Jul 2012 07:57:23 GMT

hi Swuehl,

what you mean with "and not WildMatch" ?

the script doesn't recognize the above.

hi Dimitry,

it's doesn't working....any other idea?

thanks both...

Re: Notification when selection is excluded

swuehl — Tue, 10 Jul 2012 08:06:06 GMT

Are you able to open my sample app? You should see the expression working.

I like Dmitry's expression even more, but I think there is an intersection operator missing, so if your field name is Customer and you want to notify if Daniel is excluded:

=count( {<Customer = Customer * {Daniel}>} Customer) = 0

or you can write also (but the syntax checker will mark this with as a incorrect with a red line, though the status should say 'Expression ok'):

=count( {<Customer *= {Daniel}>} Customer) = 0

Re: Notification when selection is excluded

Tue, 10 Jul 2012 08:06:09 GMT

daniel_f,

then perhaps I don't understand exactly what behavior you are expecting. A value can be

direcrtly selected (green)

indirectly selected (white)

excluded from selection (gray)

what scenario do you need to track?

Re: Notification when selection is excluded

Tue, 10 Jul 2012 08:11:54 GMT

swuhel,

you're right - intersection is missing. Correct expression as you wrote

=count( {<Customer *= {Daniel}>} Customer) = 0

Re: Notification when selection is excluded

daniel_f — Tue, 10 Jul 2012 08:55:10 GMT

Great, it's works,

i'll try to customize this solution to my needs,

thanks both