Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Not sure about your requirements, but maybe like attached, using a key for the dimensions?
Sunny has helped me on it and it is all working now. thank you both
Hi, is there any way to remove hyphen/'-' in pivot table?