topic Re: Check if there is at least one selection ? in QlikView

Check if there is at least one selection ?

fredericvillemi — Tue, 27 Mar 2018 11:02:20 GMT

Hello,

I would like to put a Calculation Condition on all straight tables if the user has not selected at least one field because I don't want people to extract a Details chart with all selections removed.

Is there an easy formula to check if there is at least one selection active on any field ?

Or the negative version : check if no selections are active ?

Thanks

Re: Check if there is at least one selection ?

swuehl — Tue, 27 Mar 2018 11:08:24 GMT

Maybe

=Len(GetCurrentSelections())>0

Re: Check if there is at least one selection ?

fredericvillemi — Tue, 27 Mar 2018 11:33:27 GMT

Thanks for your example

I've tried with =if(isnull(GetCurrentSelections()),0,1) and it works too

It was not as hard as i thought

Thanks