topic Re: Facing problem in writing a expression. in QlikView

Facing problem in writing a expression.

Wed, 05 Aug 2015 06:17:29 GMT

Hi,

I am facing a problem to write a expression.

I am attaching the demo qv app , excel data , and requirement in excel.

Please find the attachment herewith.

Please give me a needful solution to write the expression.

Thanx in advance

Regards,

Sukamal

Anonymous — Wed, 05 Aug 2015 07:18:04 GMT

Try This...

Give

Dimension as Division_Grp, Division, MTD

Expression : =MTD / AGGR(nodistinct MAX(MTD),Division_Grp)

rubenmarin — Wed, 05 Aug 2015 07:46:08 GMT

Hi Sukamal, If you want the value representes a division over their Division_grp expression can be:

Sum(MTD)/Sum(TOTAL <Division_Grp> MTD)

But it only works if you avoid to load the totals from excel and let QV to calculate. If you have Excel without the totals this can work.

Or else you can add a where clause to avoid loading totals:

Where not(Division='Men' and Division_Grp='Men') and not(Division='Ladies' and Division_Grp='Ladies');