Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Re: Sub Totals

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.

11 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach the sample file?

Regards,

Jagan.

swuehl
MVP
MVP

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.

Gabriel
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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

Not applicable
Author

I Added Explonation and sample QVW and Screenshots.

Please give any idea on this.

It's Urgent Requirement.

Thanks,

MV Reddy

Not applicable
Author

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

Gysbert_Wassenaar

See attached example


talk is cheap, supply exceeds demand
Not applicable
Author

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand