topic Re: Understand the code in QlikView

Understand the code

ishika00730 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

It would be a help if someone can explain the below code to me:

[$(=concat({1<$Table={'Sales'}>} $Field,']=,['))]=,

Regards

Ishika

Re: Understand the code

olivierrobin — Thu, 19 Apr 2018 09:16:04 GMT

it deselects all fields of table Sales

$Field= list of fields

$Table= list of all tables, matching with Sales , so only this table is selected

concat creates a list in this way field1=,field2=, .... fieldN=

and at least $(= interprets the previous result

Re: Understand the code

ishika00730 — Fri, 20 Apr 2018 02:05:53 GMT

Hi Olivier,

Thank you very much for the answer. I would like to tell you that when I use the above code, it returns me a specific field from that table. Also I tried to replace the table name with other table, in this case also it returns a particular field from the table. I want to understand the logic behind returning a particular field.

Re: Understand the code

olivierrobin — Fri, 20 Apr 2018 07:03:29 GMT

as i sayed, for me this code deselects all sélections made with fields from this table

BUT if you have other selections coming from other tables or using set analysis, these sélections remain active

Re: Understand the code

sasiparupudi1 — Fri, 20 Apr 2018 07:13:21 GMT

If you put the code in a text box you can see what the code is doing

Text box 1

=concat({1<$Table={'Sales'}>} $Field,']=[')

You will see all the fields listed in square brackets with a comma delimited except the first and the last

Text box 2

='[' & concat({1<$Table={'Sales'}>} $Field,']=[') &']='

you will see all the fields listed with in square brackets

This piece of code is generally used in set analysis if you wish to disregard the selections of all the fields from a particular table

HTH