topic Re: Help on Grid Chart in QlikView

Help on Grid Chart

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

When I am using the Grid chart, below is what I am getting which needs few modifications:

1) Y-axis (time) should be in integers only (no decimals)

2) the size of all doubles should be same

3) color of each doubles to be same (if possible)

Below is something which I am looking for:

Re: Help on Grid Chart

vishsaggi — Mon, 20 Feb 2017 15:09:46 GMT

Can you share a sample app you work on ?

For your timetaken try using this?

= Num(TimeTaken/60, '#0')

Re: Help on Grid Chart

adamdavi3s — Mon, 20 Feb 2017 15:17:21 GMT

As above for your time taken.

For the size, simply set the expression to =1

For the bubble colour, change the background colour of the expression

Re: Help on Grid Chart

sayadutt — Mon, 20 Feb 2017 16:43:00 GMT

Hi Nagaraju,

when I use = Num(TimeTaken/60, '#0'), i see below:

i just want to hide the multiple occureance of numbers in y-axis.

Below shows 5 occurrence of 1, 7 occurrence of 2 etc.

I need 1 each.

Re: Help on Grid Chart

sayadutt — Mon, 20 Feb 2017 16:43:50 GMT

Thanks Adam.

However

when I use = Num(TimeTaken/60, '#0'), i see below:

i just want to hide the multiple occureance of numbers in y-axis.

Below shows 5 occurrence of 1, 7 occurrence of 2 etc.

I need 1 each.

Re: Help on Grid Chart

vishsaggi — Mon, 20 Feb 2017 16:52:35 GMT

Can you share a sample app to work on?

Re: Help on Grid Chart

sayadutt — Mon, 20 Feb 2017 17:01:08 GMT

Hi,

I have attached 1 sample in the original post

Re: Help on Grid Chart

antoniotiman — Mon, 20 Feb 2017 17:14:21 GMT

Hi,

try

Floor([Time Taken]/60)

Regards,

Antonio

Re: Help on Grid Chart

vishsaggi — Mon, 20 Feb 2017 17:22:23 GMT

Can you try what Antonio suggested and let us know if that i what you are looking for ?

Using Antonio's suggestion try this?

= Floor(Aggr(Sum([Time Taken])/60, [Start Date Only]))

Re: Help on Grid Chart

sayadutt — Mon, 20 Feb 2017 17:36:11 GMT

Unfortunately, this time all bubbles are at integer axis.

For example if the value is 1.5, i want the bubble to be in between 1 and 2. But your solution will put that at either 1 or 2, but not in between.

See output of above:

Re: Help on Grid Chart

sayadutt — Mon, 20 Feb 2017 17:37:18 GMT

Hi Antonio,

Your solution puts the bubble at the integer y axis level.

For example if the value is 1.5, i want the bubble to be in between 1 and 2. But your solution will put that at either 1 or 2, but not in between.

See output of above:

Re: Help on Grid Chart

antoniotiman — Mon, 20 Feb 2017 18:10:40 GMT

Try

=Floor([Time Taken]/60,0.5)

Re: Help on Grid Chart

sayadutt — Mon, 20 Feb 2017 21:21:38 GMT

Hi Antonio,

This will just show 1, 1.5, 2, 2.5 in the y-axis.

My requirement is to show only 1,2, 3 .. in y axis and to plot the dots in between if it falls.

Something like below:

Re: Help on Grid Chart

sayadutt — Tue, 21 Feb 2017 10:04:16 GMT

Hi Adam,

Can you please suggest how I can display only unique values in y axis and also to display the doubles at original positions and not floor-ed them up to nearest integer.

Thanks

Re: Help on Grid Chart

adamdavi3s — Tue, 21 Feb 2017 10:16:14 GMT

Hi,

I would mess with the 'static step' option on the axis tab to get what you want,

let me just play with your app a moment

Re: Help on Grid Chart

adamdavi3s — Tue, 21 Feb 2017 10:27:51 GMT