Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two tables, Table1 and Table2 as Follows,
Table1:
ID | PNAME | MANAGER | REQUIRED |
1 | PR1 | RAM | 3 |
2 | PR2 | RAVI | 4 |
3 | PR3 | RAJ | 2.5 |
4 | PR4 | SEKHAR | 5 |
5 | PR5 | MOHAN | 6 |
Table2:
ID | PNAME | MANAGER | RESOURCE NAME | PROVIDED |
1 | PR1 | RAM | FEDRICK | 1 |
1 | PR1 | RAM | AJAY | 1.5 |
2 | PR2 | RAVI | JOHN | 2 |
2 | PR2 | RAVI | ALLEN | 1.5 |
3 | PR3 | RAJ | RAMU | 1 |
3 | PR3 | RAJ | SELVA | 1 |
4 | PR4 | SEKHAR | RAMANA | 1.5 |
4 | PR4 | SEKHAR | BHASKAR | 2.5 |
5 | PR5 | MOHAN | GANESH | 2.6 |
5 | PR5 | MOHAN | PRAVEEN | 3.4 |
My Requirement is as Follows,
DIFF=PROVIDED-REQUIRED (For example, Manager RAM has two Resources FEDRICK and AJAY, For 'FEDRICK' PROVIDED value is 1 and for 'AJAY' is 1.5. I want to sum those values(2.5) and subtract them from REQUIRED Value(3), then DIFF is 0.5)
Output Required:
ID | PNAME | MANAGER | RESOURCE NAME | DIFF(PROVIDED-REQUIRED) |
1 | PR1 | RAM | FEDRICK | 0.5 |
AJAY | ||||
2 | PR2 | RAVI | JOHN | 0.5 |
ALLEN | ||||
3 | PR3 | RAJ | RAMU | 0 |
SELVA | ||||
4 | PR4 | SEKHAR | RAMANA | 1 |
BHASKAR | ||||
5 | PR5 | MOHAN | GANESH | 0 |
PRAVEEN |
I'm new to QLIKVIEW and i tried this my level best, But i didn't get exact output.
Experts Please Can anyone have a look into this and give me suggestion.
I'm attached my sample QVW also, Please provide solution for this.
Thanks,
Chiru
see attached
Hi Hernandez,
Thanks for your Support, But my Requirement is like
ID | PNAME | MANAGER | RESOURCE NAME | REQUIRED | PROVIDED | DIFF |
1 | PR1 | RAM | FEDRICK | 3 | 2.5 | 0.5 |
AJAY | ||||||
2 | PR2 | RAVI | JOHN | 4 | 3.5 | 0.5 |
ALLEN | ||||||
3 | PR3 | RAJ | RAMU | 2 | 2 | 0 |
SELVA | ||||||
4 | PR4 | SEKHAR | RAMANA | 5 | 4 | 1 |
BHASKAR | ||||||
5 | PR5 | MOHAN | GANESH | 6 | 6 | 0 |
PRAVEEN |
Please provide some suggestion.
Thanks,
Chiru
Hi Chiru,
Is it necessary to add the Resource name in the field ?
I have attached w/o resource data.
rgds
Ashwani
Hi Please see in my attach
HI Kumar,
Yes, there should be 'Resource Name' necessarily.
Thanks,
Vamsi
Use excel. This is not possible in Qlikview.
Why is not possible? I have attached example with very similar view...
You mean you need those 2 new expressions or you need to merge cells for each resource?
Hi Hernandez,
My requirement is ID, PNAME, MANAGER should be one and RESOURCE NAME should merge, REQUIRED value should be one (Like 3), PROVIDED is sum of values based on MANAGER (Like 1+1.5 =2.5). DIff is like 3-2.5=0.5
If it is possible, Please share me.
Thanks,
Chiru