Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Greetings.
There is a year and month wise data
Year | Month | Material | qty |
2013 | jan | `A | 1 |
2013 | feb | B | 7 |
2013 | mar | B | 8 |
2013 | jan | A | 9 |
2013 | feb | A | 10 |
2013 | mar | A | 11 |
2014 | jan | B | 12 |
2014 | feb | B | 13 |
2014 | mar | A | 18 |
2014 | jan | B | 21 |
2014 | feb | A | 22 |
2014 | mar | A | 23 |
The user wants it in following format:
Year | 2013 | 2014 | Avg Qty | |||||
Material | Month | feb | jan | mar | feb | jan | mar | |
A | 10 | 10 | 11 | 22 | - | 41 | 15.67 | |
B | 7 | - | 8 | 13 | 33 | - | 10.17 |
Is this extra column of 'Avg Qty' can be added without any year and month segregation? If yes, then how?
Pls Suggest.
Attaching herewith qvw for your reference.
take a look at this
This is not you need bud ...
Thanks Enrique Colomer for your reply.
But the requirement is to add three more columns like 'Avg Qty', 'Stock in Hand', 'Avg Consumption' which shall show their total value regardless of Year And Month.
Year | 2013 | 2014 | Avg Qty | Stock in Hand | Avg Consumption | |||||
Material | Month | jan | feb | mar | jan | feb | mar | value | value | value |
A | 10 | 10 | 11 | - | 22 | 41 | value | value | value | |
B | - | 7 | 8 | 33 | 13 | - | value | value | value |
Hi,
There is some limitation of Qlikview.
One of that is you can not add Expression after Dimension.
So If possible Find Some alternative Solution.
Regards
take a look at this
hi
find attachment , hope this helps you
Hope this will help you