Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share the sample you have been working with for us to take a look at it?
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
Hi Sunny pls find the attachment. App and Xls
May be try this with an on-select trigger on AC field
Attached application seems to be working. Try it out
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
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
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
Thank you so much sunny. will check the same
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