Count with conditions with 2 tables

[saviobranco]

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 ?

[HirisH_V7]

Hi 

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.

[saviobranco]

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 ?