topic Re: Sub Totals in QlikView

Re: Sub Totals

Thu, 15 Aug 2013 10:28:19 GMT

Hi All,

I have two excel files contains tablesTab1, Tab2 AS follows

Tab1:

Staffing Profile Identifier	Project num	Project Name	Demand Resource
707963	220981	QV_Dev	4
707964	209892	QV_Dev	6
707965	209892	QV_Dev	5

Tab2:

Profile Identifier	Project Name	Allocated Resource
707963	QV_Dev	1
707963	QV_Dev	2
707964	QV_Dev	3
707964	QV_Dev	2
707965	QV_Dev	3

But Output will be in PIVOT or STRAIGHT TABLE as follows

Profile Identifier	Project Number	Project Name	Demand Resources	Allocated Resource	Gap
707963	220981	QV_Dev	4	3	1
707964	209892	QV_Dev	6	5	1
707965	209892	QV_Dev	5	3	2

i tried it using if((Staff Profile Identifier=Position Identifier),Allocated Resource,0) in Expression and i used calculated dimension also, but sometimes it works well and some times got errors.

Please Find attached Screen shots.

PLEASE Can any one look into issue, GIve me Solution.

Thanks,

MVReddy.

Re: Hi

jagan — Thu, 15 Aug 2013 10:31:49 GMT

Hi,

Can you attach the sample file?

Regards,

Jagan.

Re: Hi

swuehl — Thu, 15 Aug 2013 10:32:44 GMT

Not sure what you've done to your other thread, but AFAIR I tried to answer your question there.

No multiple posts regarding the same issue, please, it makes it hard to follow a discussion.

Re: Hi

Gabriel — Thu, 15 Aug 2013 10:34:35 GMT

Hi,

Experts here will love to help resolve this issue. However, you have not provided enough explanation, i.e. what result you want, what the issue is? e.t.c

Kindly provide more information.

From what I can glean from little inforamtion you provided above, it sounds as if you wanted to join both TABS (TAB1 & TAB2) together. If that's the case. I will suggest you use JOIN functionality.

Hope this help and look forward to more explanantion

Best Regards,

Gabriel

Re: Hi

Thu, 15 Aug 2013 14:00:34 GMT

Please Respond Anyone to this issue, It's Urgent Requirement!

Thanks To All for Your Valuable Reply,

Now i'm attaching sample QVW and my requirement is 'Position IDentifier' repeated and taking 'Allocated Resources' values repeatedly, but i want only one 'Position IDentifier' value for this i want to add multiple 'Allocated Resources'(Belongs to same 'Position Identifier') and substract them with 'Demand Resource(it's a single value)'

it's Urgent Requirement, i'm waiting for your reply.

Please Respond Anyone to this issue, It's Urgent Requirement!

Thanks,

Reddy

Re: Hi

Fri, 16 Aug 2013 13:59:07 GMT

I Added Explonation and sample QVW and Screenshots.

Please give any idea on this.

It's Urgent Requirement.

Thanks,

MV Reddy

Re: Hi

Fri, 16 Aug 2013 14:31:07 GMT

Hi swuehl,

I'm sorry about that and now my requirement has been changed thatswhy i posted in Post.

Please look into the issue, it's Urgent.

Thanks,

MV Reddy

Re: Hi

Gysbert_Wassenaar — Fri, 16 Aug 2013 15:13:40 GMT

See attached example

Re: Hi

Fri, 16 Aug 2013 18:34:53 GMT

Thank you very much Gysbert Wassenaar,

This is exactly what i needed, It's working fine but in my QVW for some values i'm getting Error values like "-5.5511151231258e-017", "2.2204460492503e-016", " -4.4408920985006e-016".... ,i attached sample screen shot also.

Rest of all things are working fine.

i tried to replace them with '0', but it didn't work.

I'm attaching my QVW, Please have a look into this issue.

Thanks for your valuable support to us.

Thanks,

MV Reddy

Re: Sub Totals

Gysbert_Wassenaar — Tue, 20 Aug 2013 17:02:08 GMT

Try using the round or floor function: for example round(AllocatedR-Demand,0.001)

Re: Sub Totals

PradeepReddy — Tue, 20 Aug 2013 18:34:42 GMT

We can achieve this using simple Join. (Join on Profile Identifier)

I have done the bellow process.

1. Load the first tab

2. While Loading the second tab use the "Group By" and "Sum" functions.

3. In chart, use the expression as "=Demand-Actual"

Re: Hi

Thu, 22 Aug 2013 09:37:17 GMT

Thanks Wassenaar,

It's working fine now.

Thanks for your support.

Thanks,

VAmsi