Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

Help needed in converting this SQL Query to Qlik Query

Hi All, 

I have this Attched Query and have to convert it or implement it in the Qliksense, 

Intention here to calculate the Churn rate of the customers. i have 2 tables one is called churn and other is Base table. both have duplicates in there primary keys and suggested to join on 3 columns.

Please help me how can I build this relation between Churn table and Base table. 

Appreciate the help if any one suggest me how I can relate these 2 tables Based on the attached. 

 

@sunny_talwar @jagan  please any inputs

Labels (3)
1 Reply
Andrew_Delaney
Support
Support

The best place to start is probably the help on loading data into Qlik Sense, you should be able to use an odbc connector to load these tales into your sql app, or use your sql query itself