Chart (Line Chart) Issue?

[Anil_Babu_Samineni]

Hello,

Updated by Anil:

I hope all is well with QlikView..

I have one Excel, In that.. In that i have fields like -- Date, Sales..

So, once i apply to Line Chart. I want to achieve in bar chart show current month, previous month, last year current month.

Ex:- Let's Say, if i select May - 2016 on dimension i want in bar chart like -- May - 2016 and April - 2016 and May - 2015

Note: Please find O/P like attached Image for Reference..! I am expecting Line Chart

[swuehl]

You can do this using set analysis, have a look for example at

The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync

[Anil_Babu_Samineni]

Swuehl, Can you please post me the expression's for those three which you have on wall. Current Month --> ? Last Month --> ? Last Year Current Month -->

[sunny_talwar]

Anil we can be of better help, if you are able to provide us with a sample qvw or at least some data in Excel file with the expected output. It is not that we are unable to create a sample, but if we do there are two issues

1) Our guess about the data structure you might have would be as good as a guess. Which mean it would take a lot of time and effort on both our parts to come up with a solution

2) It is a lot of effort on our part to create a dummy data set which may not even be of any help in the end. Trust me this can be very annoying at times.

So please spend some time to create a sample and share that with us to help us help you in a better way

Preparing examples for Upload - Reduction and Data Scrambling

[ajsjoshua]

Hi,

PFA

[Anil_Babu_Samineni]

Sunny,

PFA.

[Anil_Babu_Samineni]

Joshua,

Need not to show 4 months, Only 3 months i.e current month,  previous month, last year current month.

And the months showing aug2016, july 2016, aug 2015, jan 2015 Not like that

This is in bar chart i need in line chat..!