QlikSense - Difference in Values on Bar Chart for Current Month and Previous Month

[#1]

Hi All,

I have below query regarding bar chart and value calculation.

I have loaded the data to QlikSense . My data is in below format

Product	Date	Value	Expected Result - Difference between Value of this Month end date and Previous Month end date
A	31-Jul-17	200	100
A	30-Jun-17	100	20
A	31-May-17	80
B	31-Jul-17	500	300
B	30-Jun-17	200
C	31-Jul-17	100	-200
C	30-Jun-17	300

I want to show the Resultant value i.e. the difference between current and previous month value on the BAR CHART. Additionally, my date column is in format dd-mmm-yy.

I was able to create the bar chart but unable to find out how to create a column for difference of month end values and showing them on bar chart when those two months are selected on QlikSense.

Also please help me out with showing the date as below

Current format	Expected
31-Jul-17	Jul-17
30-Jun-17	Jun-17
31-May-16	May-16
31-Jan-16	Jan-16

Thanks in advance

[antoniotiman]

Hi,

See Attachment.

Regards,

Antonio

[#3]

Hi Antonio,

I am unable to open the attachment in QlikSense. I am using QlikSense Desktop, may be this file isnt compatible. Can you please paste it here , or send me a file compatible with QlikSense Desktop.

Thanks

[antoniotiman]

I'm sorry,

See new Attachment.

[#5]

I am sorry, but I am still not able to open using QlikSense. Getting error as "Bad command line arguments"

Can you please paste the screenshot or the code here.Thanks

[antoniotiman]

Script

SET DateFormat='DD-MMM-YYYY';

LOAD *,MonthName(Date) as MonthName Inline [

Product, Date, Value

A, 31-Jul-17, 200 

A, 30-Jun-17, 100

A, 31-May-17, 80

B, 31-Jul-17, 500

B, 30-Jun-17, 200

C, 31-Jul-17, 100

C, 30-Jun-17, 300 ];