Hello,I have startedto useQlikView, and let me knowifit is possible toload data froma SQL queryin atable box "withrestrictions", since the currentwayI do itduplicates the results ofthe query. To do this I made a sql query, but I do not know how to the table is formed according to this consultation. My SQl query:
It looks like you did everything correctly, and the Table box shows all the possible combinations of the 4 fields that you included in it.
There is no direct load into table boxes from the script. You load the data into fields in the script, and then in the UI, you show the data using the sheet objects.
It's a common mistake to think that the Table Object will show the direct results from the SQL Load. The table will show all possible combinations of the selected Fields, eliminating duplicates. The output will be very close, but not necessarily the same as the original data in the SQL table.