Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
HWallays
Contributor III
Contributor III

From Qview to Qsense - use of $Field in visuals

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  ?

 

 

 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

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.  

GaryGiles_0-1623757971034.png

 

View solution in original post

5 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

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

GaryGiles
Specialist
Specialist

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.  

GaryGiles_0-1623757971034.png

 

HWallays
Contributor III
Contributor III
Author

Hoi JuanGerardo : the purpose is to see actually all the values ... (maybe I was not clear enough, sorry... 

HWallays
Contributor III
Contributor III
Author

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 ...    

HWallays
Contributor III
Contributor III
Author

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