hi All,
I have been discussing a challenging request on the QlikView Side. Now I need to do the same thing in Sense.
Attached is a QlikView and a QlikSense Document and both of them have the same pivot table. on QlikView the logic works fine but on Sense it doesnt.
my request is as follow
the source is the upper table which looks like
| 5/18/2016 | test | $ 254.00 |
| 6/15/2016 | test | $ 200.00 |
| 7/20/2016 | test | $ 500.00 |
| 8/17/2016 | test | $ 300.00 |
and the result table is as follow
| Date | 5/18/2016 | 6/15/2016 | 7/20/2016 |
| 5/18/2016 | $ (54.00) | $ 246.00 | $ 46.00 |
| 6/15/2016 | | $ 300.00 | $ 100.00 |
| 7/20/2016 | | | $ (200.00) |
Let me know if anyone knows how to handle it in Sense..
