Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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 ?