topic Re: Problem with data model in QlikView

Problem with data model

Sun, 12 Oct 2014 17:14:41 GMT

Hi All,

I have 3 tables PNL, Billing, Revenue. i used Billing doc num as common key for this tables (Please check the data model).

Based on requirement i used expressions and i'm getting data correctly but values are repeating and also

for Expression1 i'm getting sum of the value instead of individual value (193+193+121=507).

i'm not getting total value of second expression also.

could you please help me to get the data as below

i'm also attaching QVW, Could you please anybody give the solution asap would be great for me.

Thanks,

Re: Problem with data model

Mon, 13 Oct 2014 04:13:53 GMT

Hi Guys,

it's an urgent requirement, could you please anybody help on this?

Thanks,

M V

Re: Re: Problem with data model

PrashantSangle — Mon, 13 Oct 2014 05:05:32 GMT

Hi,

Kindly find attached application,

It is as per requirement.

Regards,

Re: Re: Re: Problem with data model

Mon, 13 Oct 2014 05:32:30 GMT

Hi Max,

Thank you very much for your reply.

For first expression it is working fine but for second expression (based on some conditions) values are not coming.

Could you please take a look into this.

Thanks,

M V

Re: Problem with data model

jagan — Mon, 13 Oct 2014 05:44:12 GMT

Hi,

Try this expression

sum(aggr(if(Match(DOC_TYPE, 'Q1', 'D4', 'Z4') AND Match([Accrued_Revenue_Clearing_GL_Account_Id], '2507RR9999', '2509RR9999'),

Sum(Amount2)-sum(Amount1),if([Offsetting_GL_Account_Id]='1221RR9999',sum(Amount1))),Key1))

Regards,

Jagan.

Re: Problem with data model

PrashantSangle — Mon, 13 Oct 2014 05:49:02 GMT

Hi,

Try this expression,

Sum(aggr(if([Accrued_Revenue_Clearing_GL_Account_Id]='2507RR9999' or [Accrued_Revenue_Clearing_GL_Account_Id]='2509RR9999',
Sum(Amount2)-sum(Amount1),if([Offsetting_GL_Account_Id]='1221RR9999',sum(Amount1))),Key1))

Regards

Re: Problem with data model

Mon, 13 Oct 2014 05:50:17 GMT

Hi Jagan,

Thanks for your reply.

If i use the above expression i'm getting 0 as values.

if possible could you please take a look into this.

Thanks,

M V

Re: Re: Problem with data model

jagan — Mon, 13 Oct 2014 06:05:58 GMT

Hi,

Check this file attached.

Regards,

Jagan.