topic Re: Need to Reload the data based on list box value selection in QlikView

Need to Reload the data based on list box value selection

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Goal: Need to Reload the data based on the selection made in list box at dashboard level.

Variable created using variable Overview dialog ==> vAcc = getfieldselections(AC)

Result of variable would be - either ADMIN or USER.

Obsesrvations:

Though the variable vAcc is holding the value, but on reload the table is fetching 0 records.

Please let me know if missing anything

(or)

Is there any way to achieve this?

Thanks in advance

Re: Need to Reload the data based on list box value selection

sunny_talwar — Fri, 29 Jul 2016 09:41:05 GMT

Would you be able to share the sample you have been working with for us to take a look at it?

Re: Need to Reload the data based on list box value selection

Peter_Cammaert — Fri, 29 Jul 2016 09:52:32 GMT

In your script, change clause

WHERE ACCESS = '=vAcc';

into

WHERE ACCESS = '$(vAcc)';

I think i got what you were after, but that doesn't work in a script. $-sign substitution on the other hand will work perfectly, even in SQL statements. Note: make sure that variable vAcc always contains exactly one value.

Best,

Peter

Re: Need to Reload the data based on list box value selection

Fri, 29 Jul 2016 10:14:55 GMT

Hi Sunny pls find the attachment. App and Xls

Re: Need to Reload the data based on list box value selection

sunny_talwar — Fri, 29 Jul 2016 18:13:57 GMT

May be try this with an on-select trigger on AC field

Attached application seems to be working. Try it out

Re: Need to Reload the data based on list box value selection

Mon, 01 Aug 2016 05:10:06 GMT

Thank you sunny. Its working fine.

Have one more Question.

I am trying to implement the same in Qlik Sense.

Can you suggest on this, as there are no direct triggers available in Qlik sense like Qlik View.

Thanks

Re: Need to Reload the data based on list box value selection

Mon, 01 Aug 2016 05:14:49 GMT

And also,why it did not work with the variable concept(Used Filed triggers).

Is there any specific reason for this or kind of implementation mistake?

Thanks

Re: Need to Reload the data based on list box value selection

sunny_talwar — Mon, 01 Aug 2016 10:15:42 GMT

I think for Qlik Sense you will need an extension to get this done. I don't have much expertise in Qlik Sense to guide you in the right direction, but may be phaneendra.kunche can offer his advice regarding an extension that might help do this for you.

To answer your 2nd question. GetFieldSelection is a front end function. Whatever you have selected doesn't carry through to the back-end unless you have saved it as a value instead of a function.

HTH

Best,

Sunny

Re: Need to Reload the data based on list box value selection

Mon, 01 Aug 2016 10:23:39 GMT

Thank you so much sunny. will check the same

Re: Need to Reload the data based on list box value selection

kaushiknsolanki — Mon, 01 Aug 2016 10:54:52 GMT

Hi,

You shouldnt declare the variable in script when you want to use that in calculation by taking input from frontend.

Your script should be.

LOAD Distinct ACCESS as AC

FROM

[..\TestData.xlsx]

(ooxml, embedded labels, table is Sheet1);

Data:

LOAD ACCESS,

NAME,

VALUE

FROM

[..\TestData.xlsx]

(ooxml, embedded labels, table is Sheet1)

where ACCESS = '$(vAcc)';

Regards,

Kaushik Solanki