topic Re: Count with conditions with 2 tables in App Development

Count with conditions with 2 tables

saviobranco — Thu, 21 Mar 2019 19:33:42 GMT

Hi everyone !
I'm new to Qlik and couldn't find an answer for my question on the forum

I have 2 tables.

In Table_1 i have ID, Status,city, etc...Table_2 product,ID, description, etc...
Status can be ON or OFF

I need to count by product the ID with the status is ON.

How can i do it ?

Re: Count with conditions with 2 tables

HirisH_V7 — Thu, 21 Mar 2019 20:43:52 GMT

you need to join your tables whether using join or applymap which ever permits.

Then while calling into resident, there you can count with your condition using groupby.

Re: Count with conditions with 2 tables

saviobranco — Fri, 05 Apr 2019 13:09:33 GMT

Hmm, got it.
Now that we have talked about it...

Im just started to use and learn about Qlik.
And im seeing that a lot of solutions comes to the use of the AQL language for manipulate the data.

I tought that would be possible to do the majority of things just by drag and clik.
But im seeing that i have to do a lot of things with AQL and writing expressions.

My point is:
what is the advantage of using QLIK rather than using SQL for the heavy lift and some language/framework for visualization like Python,R or D3.js ?