topic Requirement on bar chart in QlikView

Requirement on bar chart

Wed, 25 Nov 2020 16:16:04 GMT

I have four Date fields i.e G1,G2,G3,G4 .i need to show all these four dates on one bar like below image

Re: Requirement on bar chart

Mon, 30 May 2016 18:18:21 GMT

Here is the sample data

Note:i have already implemented gannt chat on the bar

Thanks in Advance..........!

Re: Requirement on bar chart

swuehl — Mon, 30 May 2016 18:23:57 GMT

How exactely do you want to show these records from your excel file?

Your data shows multiple records per Num field, and G1,G2,G3,G4 don't seem to be in chronological order, sometimes G1 is smaller than G2, sometimes G2 smaller than G1.

Could you create a sketch drawing how you want to show your sample data?

Re: Requirement on bar chart

Mon, 30 May 2016 18:42:03 GMT

these fields are coming from Data base .i have created sample excel file .if is there any possibility to show all these G1,G2.G3,G4 as shown above image .

Note: G1 ,G2,G3,G4 need not to be in chronological order.

Re: Requirement on bar chart

sunny_talwar — Mon, 30 May 2016 18:47:24 GMT

I think you missed Stefan's comment on creating a rough sketch. I don't know about Stefan, but I still have no idea how you would want to see this information on a chart. A chart drawn on a paper will work if you can at least give us some direction.

Re: Requirement on bar chart

swuehl — Mon, 30 May 2016 18:59:44 GMT

Or mybe rephrase it this way:

G1, G2, G3, G4 are dates, values of point in time.

Your image above seems to indicate some kind of periods of time (see the bars, when considering the axis a time axis), but I am unsure how you derive the length of the bars from your G1 etc. data.

Second issue that needs to be defined: How do you want to aggregate your field values across Num dimension?

Re: Requirement on bar chart

Mon, 30 May 2016 19:12:42 GMT

Num is id field when i select any Num then only That Bar appears dashboard .yes that chat shows duration only (Gannt Chart) and on that chart i need to laying G1,G2,G3,G4 dates.