topic Re: Chart (Bar graph) Issue? in QlikView

Chart (Line Chart) Issue?

Anil_Babu_Samineni — Tue, 03 May 2016 06:42:37 GMT

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

Re: Chart (Bar graph) Issue?

swuehl — Tue, 03 May 2016 13:14:22 GMT

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

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

Re: Chart (Bar graph) Issue?

Anil_Babu_Samineni — Tue, 03 May 2016 13:29:41 GMT

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

Re: Chart (Bar graph) Issue?

sunny_talwar — Wed, 04 May 2016 02:28:26 GMT

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

Re: Chart (Bar graph) Issue?

ajsjoshua — Wed, 04 May 2016 05:08:01 GMT

Hi,

PFA

Re: Chart (Bar graph) Issue?

Anil_Babu_Samineni — Wed, 04 May 2016 06:17:24 GMT

Sunny,

PFA.

Re: Chart (Bar graph) Issue?

Anil_Babu_Samineni — Wed, 04 May 2016 07:07:58 GMT

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