Need help to undersatnd the formula

[kumarleau]

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

[Lisa_P · Accepted solution]

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

[kumarleau]

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

[Lisa_P]

Yes. But this syntax will not work in a load statement, just in the visualizations

[kumarleau]

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.