topic Re: Select In Field function to activate a variable in QlikView

Select In Field function to activate a variable

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am trying to activate a variable by selecting a dimension in a straight table

Is this possible?

Regards

Re: Select In Field function to activate a variable

tresB — Wed, 02 Nov 2016 05:07:58 GMT

If you want to select a value from a field and get that value in a variable, you have to just define your variable like:

vVariable=FieldName

Re: Select In Field function to activate a variable

its_anandrjs — Wed, 02 Nov 2016 08:01:34 GMT

Hi,

On selection of the dimension in straight table if you need to fetch the selection then use in a variable.

vSelectionvar = GetFieldSelections(Here Your Dimension Field Name)

Ex:-

vSelectionvar = GetFieldSelections(Product)

vSelectionvar = GetFieldSelections(Year)

Regards

Anand

Re: Select In Field function to activate a variable

rahulgupta — Wed, 02 Nov 2016 08:17:48 GMT

Hi Kevin,

I have made the same requirement available in my recent project.

Requirement: A Straight Table contains say Product as Dimension & Sum(Sales) as Expression. User wants on the selection of any Product in the Straight Table an alert on the Right Top Corner.

Resolution: In text object, we put the expression as "=If(GetPossibleCount(Product)>0, Red(), Green())". This turns the text object to Green when nothing is selected and to Red when any one selection is made Straight Table.

Hope this helps.

Regards

Rahul

Re: Select In Field function to activate a variable

tresB — Wed, 02 Nov 2016 08:33:50 GMT

Hi Rahul,

I guess you meant to use GetSelectedCount(), right? Otherwise, if you select or not GetPossibleCount() would always return value >0 (excluding a case when you select all and then do an inverse selection 'Select exclude').

Re: Select In Field function to activate a variable

Thu, 10 Nov 2016 10:02:53 GMT

Thank you. Got it working