Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

Chart (Line Chart) Issue?

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

738cd762-3a83-476d-b861-3ba592c46b0a.jpg

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
6 Replies
swuehl
MVP
MVP

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
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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
Specialist
Specialist

Hi,

PFA

Anil_Babu_Samineni
Author

Sunny,

PFA.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anil_Babu_Samineni
Author

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..!

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful