Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use of SQL in Qlik Sense

Hello Community,

i just started to use Qlik Sense at my workplace and i am also pretty new to SQL. I have to do a visualization of customers per Region. My question is, how can i add a column to a table in qlikview where i use the following command for in SQL :

select plz_2stellig, sum(einwohner) from pr_dbmk444plz_bb where plz_2stellig is not null

group by  plz_2stellig;

Can anyone hep me?

Greetings

1 Reply
sunny_talwar

I guess use that in the script

TableName:

SQL Select

     plz_2stellig,

     Sum(einwohner)

FROM pr_dbmk444plz_bb

WHERE plz_2stellig is not null

GROUP BY plz_2stellig;

Once you reload this, you should be able to create your visual.