Notification when selection is excluded

[daniel_f]

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

[swuehl]

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

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

[#3]

conditional show

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

[daniel_f]

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...

[swuehl]

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

[#6]

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?

[#7 · Accepted solution]

swuhel,

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

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

[daniel_f]

Great, it's works,

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

thanks both