Hello, I have started to use QlikView, and let me know if it is possible to load data from a SQL query in a table box "with restrictions", since the current way I do it duplicates the results of the 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:
- SELECT DISTINCT
With this query results are not duplicated, but not how to make the display table in Qlikview, I've now done shows as follows:
and this is the interface structure QlikView:
I researched a bit, and I think I need to load it from the script, but not sure, I hope you can help me.