Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Help to simplify an expression in a pivote table

Hi Guys, I really need help to simplify an expression in a pivote table, there are too many nested if´s and this makes it limited, but I need to include all my rows of my field "ACCOUNT_NAME" ,

I attached the app for a better understand.

Thank you all Gyus for your time!!

1 Solution

Accepted Solutions
chandashok
Contributor III

Re: Help to simplify an expression in a pivote table

Hi

     Hope this expression will be helpful for your problem

=

sum( aggr(

             IF(ACCOUNT_NAME = 'NOMINA_HRAS', sum({$<ACCOUNT_NAME = {'MINA_HRAS'}>}[Costo por hora]* [Hrs Reales]),SUM(Gastos))

,ACCOUNT_NAME,COCE_NAME))

+

sum({$<ACCOUNT_NAME = {"NOMINA_HRAS"}>}[Costo por hora]* [Hrs Reales])

I attached your qv file with the solution . Refer it the chart having caption answer.

Regards

Ashok

2 Replies
chandashok
Contributor III

Re: Help to simplify an expression in a pivote table

Hi

     Hope this expression will be helpful for your problem

=

sum( aggr(

             IF(ACCOUNT_NAME = 'NOMINA_HRAS', sum({$<ACCOUNT_NAME = {'MINA_HRAS'}>}[Costo por hora]* [Hrs Reales]),SUM(Gastos))

,ACCOUNT_NAME,COCE_NAME))

+

sum({$<ACCOUNT_NAME = {"NOMINA_HRAS"}>}[Costo por hora]* [Hrs Reales])

I attached your qv file with the solution . Refer it the chart having caption answer.

Regards

Ashok

Not applicable

Help to simplify an expression in a pivote table

Yes, It works excellent, Thank you chandashok, I really need it.

Have a good one, and thanks again!!

Community Browser