Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andre_tonini
Creator II
Creator II

SUM no Script

Pessoal,

       Estou fazendo a leitura de uma planilha do excel, onde preciso saber o total de horas extras durante o mês.

       No script grifado abaixo, preciso que o campo Hora_Extras_F seja na realidade SUM(Horas_Extras_F) mas não funciona no IF o sum, tem alguma outra forma?

        Exemplo eu precisaria da seguinte forma, dai funcionaria para mim
        IF(SUM(Hora_Extra_F) > 120 ,'100_PORCENTO','50_PORCENTO') AS SITUACAO_HORAS;  

1.png

Att,

André Tonini

1 Solution

Accepted Solutions
prma7799
Master III
Master III

You want this in back end itself? Please share some sample app or try to use group by clause in script.

View solution in original post

2 Replies
prma7799
Master III
Master III

You want this in back end itself? Please share some sample app or try to use group by clause in script.

Anil_Babu_Samineni

Condition works, But you need with Group By clause for Non-Aggregate fields in your Load statement.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)