topic Re: Re: Need Help.. in QlikView

Need Help..

Nagaraju_KCS — Fri, 11 Jul 2014 07:29:02 GMT

Hi Community,

PFA,

I have 2 dimensions and 2 expression.

first expression coming based on 2 dimensions.

but my second expression i want show based on only one dimension.(Month based)

Thanks in advance..

maxgro — Fri, 11 Jul 2014 07:51:14 GMT

sum({<Type={SALES,GRC}>}total <MonthYear> Quantity)

sum(total <MonthYear> Quantity)

Gysbert_Wassenaar — Fri, 11 Jul 2014 07:53:44 GMT

See attached qvw

Nagaraju_KCS — Fri, 11 Jul 2014 08:55:12 GMT

Hi Gysbert,

PFA,

Data is correct, but i need in expression only,..

i want to show same data in all Sales columns.

Hope you understand...

jagan — Fri, 11 Jul 2014 09:02:18 GMT

Hi,

Try this expression

=Sum(TOTAL <MonthYear> Quantity)

Regards,

Jagan.

Nagaraju_KCS — Fri, 11 Jul 2014 09:07:36 GMT

Hi Jagan,

This data correct... if i am using this =Sum(TOTAL <MonthYear> Quantity) it showing wrong data...

See here, sales column data i want to show all sales column.

Gysbert_Wassenaar — Fri, 11 Jul 2014 09:10:21 GMT

Try this expression: sum(total <MonthYear> aggr(sum({<Type={'SALES'}>} Quantity),[MonthYear]))

Nagaraju_KCS — Fri, 11 Jul 2014 09:17:15 GMT

Thanks Gysbert..