Discussion board where members can get started with Qlik Sense.
How can I achieve below table in qliksense.
In That :
Product Is my Dimension
MonthYear is my Column
Exp1 and Exp2 is my measures .
Please guide me.
Go to Solution.
Find the expected output in attached QVF.
Please help ,
Any Extension or is this possible in pivot or not.
Thanks for reply ,
but what you gave me that is not what i actually looking for.
Then what are you looking for?
The output is similar to what you have shown in image.
One way to do this would be to load a new field when you load your data.
In your chart calculation, calculate Exp1_ToDate_CY - Exp1_ToDate_PY.
This code is not tested and you may get a syntax error. But you'll get the logic here.
Let me know if this works out for you.
Sorry My Bad.. It seems i uploaded a wrong one.
I have changed it. Please check new one.
Thanks for prompt response.
no its completely different you gave me one scatter chart and one text object .
I require pivot table in above mentioned format.
In my previous post. Replaced the old one with new one.
You can see a name difference i.e New file name is Comm285777.qvf
No its not that way. I have already Year month wise data I want it on pivot table