Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai,
I'm in the process form switching over from QView to Qsense and busy setting over my Qview dashboards into QSense.
With one of the dashboard I do not seem to find the solution 😉 as the Qlikview formula is not accepted in Qliksense 'as is'.
What do I do :
- in order to spare on creating numerous Visuals on a variety of dimensions
- I created a list box with the values via the $Field (in which user can select a field )
- In the Visual I then perform the visual on the content of the selected field via =[$(=$Field)] and even inorporate it in functions to display/analyze like count(), length, isnull ….
Maybe an example about displaying the dipsersion of the population within that field on the lenght of the field which the user selects (eg. to check if Phone numbers are valid or not …)
In the dimension I would use =Len(Trim([$(=$Field)]))
In the measure I then write Count([$(=$Field)])
But although I can use =$Field (this works and delivers me the fieldname that was selected ) in Qliksense I can no longer display the content of the selected field as I did in QView with this forumla =[$(=$Field)]
Should I use other brackets or formula to get this ?
Interesting. I am able to get the content of the selected field using =[$(=$Field)] in a table. See below. I am using the September 2020 release of Qlik Sense.
As you can have more than one value selected/possible, you need to get the field when only one value is selected, for example with Only(), for example:
=Only($Field)
=Count([$(=Only($Field))])
If you don't select only one value, $Field is not a value but an array of values.
JG
Interesting. I am able to get the content of the selected field using =[$(=$Field)] in a table. See below. I am using the September 2020 release of Qlik Sense.
Hoi JuanGerardo : the purpose is to see actually all the values ... (maybe I was not clear enough, sorry...
Hai Gary ... now I am puzled indeed because this is exactly/indeed what I need it todo 😉 .
VERSION : We seem to be on the november 20 patch 6 version , so I do not think this will be the issue.
I will come back with my example in a few hours , have to leave for a while now , but will display the data and results both in QV and QS later this evening
Thanks already for your help ...
Hai Gary & JuanGerardo : apparently the day after when re-copying the formula (used in QV ) into QS seem to work, so the problem is fixed and must have been some kind of glitch at the technical (internal) side(we even tried with 2 people overhere getting the same results). Anyway now things are again for the best and we can now work out generic visualisations vdriven bij the choice of the fields & tables which the user selects...
So we are prepared for other new QS adeventures and maybe tryout some of the new graphs ...
Thanks for both your (appreciated) replies