Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alislais
New Contributor

Draw tables using SQL-like statements

Hi,

I have two questions about Qlik Sense Desktop:

  • Is there a way to draw a straight table directly using SQL-like statements? I understand that there is a data load script that can be used (which is very useful), but for me it lacks one important feature. The table generated loses its relationship with other tables, so it is not affected by any filters applied. I think this is the nature of data load scripts. I am also familiar with aggr() function, but I think it complicates the logic.
  • Suppose that I have already a drawn straight table or any chart item. Is there a way that I can manipulate the data presented using JS for example (APIs)? i.e. I get the data in, let’s say, JSON format and then manipulate it and then draw it again? Of course by doing this I expect that the data lose its relationships with others, which is totally acceptable.

Thanks,

Labels (1)
3 Replies

Re: Draw tables using SQL-like statements

1. No, You can't perform SQL Queries in Front end where as You can define in script.
2. What you want to play with API's. Can you describe little more
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
alislais
New Contributor

Re: Draw tables using SQL-like statements

So suppose that I have a straight table. Since I cannot use SQL to reach the results I want, I am okay to take another approach such that I manipulate the data using a programming language. For example, I can introduce a new hierarchy levels and aggregate the values based on some conditions and then draw a pivot table, transpose, or transfer the table. Basically I am free to get data in a special format and then produce it again with the same format.

Highlighted

Re: Draw tables using SQL-like statements

Do you have any reference - What we are talking about?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)