Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Avg( Aggr( Sum(Qtyl), Date))
The above expression worked to some extent.
Now When i am drilling down to the final date, Its not giving me the correct answer.
I have my data as -
Date | Dept | WorkCenter | Sub Dept | Qty | Co. Code | Type |
2-Jan-17 | Mfg | A | PURE | 10 | ZZ | Gold |
2-Jan-17 | RM | B | KARAT | 30 | XX | Platinum |
2-Jan-17 | Mfg | C | PURE | 30 | YY | Silver |
2-Jan-17 | JW | A | SPRUE | 20 | ZZ | Platinum |
2-Jan-17 | Mfg | D | FIL | 40 | XX | Gold |
2-Jan-17 | RM | D | BAG | 50 | YY | Silver |
3-Jan-17 | Mfg | A | CHK | 10 | WW | Platinum |
3-Jan-17 | JW | B | FIL | 20 | VV | Gold |
3-Jan-17 | Mfg | C | FILWIP | 20 | WW | Gold |
3-Jan-17 | JW | B | CHK | 10 | VV | Silver |
3-Jan-17 | RM | C | FIL | 30 | XX | Platinum |
3-Jan-17 | RM | B | BAG | 30 | ZZ | Platinum |
3-Jan-17 | Mfg | A | CHK | 20 | YY | Silver |
4-Jan-17 | JW | B | FIL | 50 | VV | Gold |
4-Jan-17 | Mfg | C | FILWIP | 10 | WW | Gold |
4-Jan-17 | RM | B | BAG | 20 | VV | Silver |
4-Jan-17 | Mfg | C | FIL | 40 | XX | Platinum |
4-Jan-17 | JW | A | AAG | 40 | ZZ | Silver |
4-Jan-17 | Mfg | D | FIL | 20 | WW | Gold |
4-Jan-17 | RM | A | AAG | 10 | YY | Platinum |
I need to check drill down on a single date say 2nd Jan = Total Inventory of Qty = 180
Note this is sample data and will contain data from 1st Jan to 31st Oct.
Thanks,
Vikas
Show me the image of expression with full image
Here Total(Pure)=Qty (Field)
Extremely Sorry, Question related Qliksense. But, You make sure to mention "In Place" should be Qliksense. So, It is not existing function for sense. May be someone offer you
Didn't get you on that one
If you give proper answer, Then we will get answer for you. From given data what are you going to get using simple Straight table? So, Then we can make for you
Hi,
I am giving you proper answer.
My final aim is-
1. To get average inventory department wise whenever I am at multiple dates or at clubbed Month Level
2. When I select a single date from filter, I should get total or Sum for that date
Vikas
Hi Anil,
I tried this one
And It worked
Thanks for the help.
I appreciate.