Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I don't know anything about Qliksense/QlikView. I just want to understand one
Sum(aggr(sum({<[Status]={'Open'}>} [Duration]),[Name]))
What it is doing exactly.
Can someone help me how to convert this into SQL query
Regards,
Kumar
Hi Kumar,
Let me break it down for you. This is using Set analysis and the aggr function.
Sum( // sum total of the each Sum(Duration) by Name
aggr( // aggr is aggregating the measure, Sum(Duration) by Name
sum( // sum of Duration
{<[Status]={'Open'}>} // where Status = Open
[Duration])
,[Name]) // broken down per Name value
)
Hope this helps
Hi Kumar,
Let me break it down for you. This is using Set analysis and the aggr function.
Sum( // sum total of the each Sum(Duration) by Name
aggr( // aggr is aggregating the measure, Sum(Duration) by Name
sum( // sum of Duration
{<[Status]={'Open'}>} // where Status = Open
[Duration])
,[Name]) // broken down per Name value
)
Hope this helps
Thanks a lot for responding to my query.
So if i am not wrong the sql query is like as below
select sum(duartion) from table where [Status]='Open' group by Name
Can you correct me if I am wrong.
Regards,
Kumar
Yes. But this syntax will not work in a load statement, just in the visualizations
Thanks. This qlik formula I have to convert into sql for some other purpose.
This is the reason I am trying to understand the qlik formula.
Thanks once again for giving valuable suggestion.