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

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

Thu, 03 Aug 2017 17:20:35 GMT

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

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

antoniotiman — Thu, 03 Aug 2017 17:57:01 GMT

Hi,

See Attachment.

Regards,

Antonio

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

Thu, 03 Aug 2017 18:01:12 GMT

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

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

antoniotiman — Thu, 03 Aug 2017 18:13:41 GMT

I'm sorry,

See new Attachment.

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

Thu, 03 Aug 2017 18:21:38 GMT

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

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

antoniotiman — Thu, 03 Aug 2017 18:28:57 GMT

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 ];