topic Re: Qlikview Chart in QlikView

Qlikview Chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can we create these type of charts in Qlikview version 12.

Re: Qlikview Chart

adamdavi3s — Mon, 09 Jan 2017 13:16:16 GMT

It might be possible with some trickery but not as standard and not without more information!

Re: Qlikview Chart

MK9885 — Mon, 09 Jan 2017 13:24:58 GMT

I don't think so, at least in Qlik view.

It looks too fancy.

Re: Qlikview Chart

ramasaisaksoft — Mon, 09 Jan 2017 13:44:58 GMT

Sorry vivek,

As per my knowledge we don't have that much capability in Qlikview.

Enthusiastically i am asking from which technology you took these charts ?

Re: Qlikview Chart

vinieme12 — Mon, 09 Jan 2017 14:34:08 GMT

Close Enough i Think ! Thanks for the exercise

Re: Qlikview Chart

vinieme12 — Mon, 09 Jan 2017 14:58:09 GMT

Fine tuned to edit number of bands needed with variable

Re: Qlikview Chart

Tue, 10 Jan 2017 05:02:22 GMT

@Vineeth Pujari Can you please elaborate your Comment..Can you share the procedure of this chart

Re: Qlikview Chart

Tue, 10 Jan 2017 06:05:35 GMT

Hi Vivek

Have a look at Qlik Branch, There might be a chart close to those you want or something different that might work.

Kind Regards

Re: Qlikview Chart

vinieme12 — Wed, 11 Jan 2017 10:46:05 GMT

Hi Vivek,

I noticed the scales were off so I've made amendments also the segments are now ~EQUAL Width; attached is an updated version.

Also attaching excel file to show Calculations

Each Bar is basically split into multiple segments

Example lets discuss Cat3

Cat4 = Amount = 390

390 = 390/780 = 50%

So out of 20 segments we will have 20*50% of segments = 10 Segments out of 10 Segment 5 segments are going to be transparent.

Each segment is = 39 ie 390/10

Re: Qlikview Chart

MK9885 — Wed, 11 Jan 2017 12:48:37 GMT

Hi,

vinieme12

Do you remember modifying the .js to add more columns for an extension?

I know this is totally different topic but can you paste that .js so that I can check it?

Cus I modified the java script to increase qWidth from 20 to 50 but nothing happens...

Please let me know if you can suggest anything or have a modified extension already stored with you?

Thanks.

Re: Qlikview Chart

vinieme12 — Wed, 11 Jan 2017 13:00:52 GMT

There is no java script / no extensions involved , purely achieved with calculations.

If you want to have more bands change the DIM inline load, but that'll only reduce the width of the bands

Load

1 + Recno()-1 as DIM

AutoGenerate (50);

Re: Qlikview Chart

MK9885 — Wed, 11 Jan 2017 14:12:32 GMT

I believe you misunderstood my question.

I'm talking on different topic.

We've a Qlik Sense extension, Dynamic Sparkline Table, right and then Export to XL button.

But the problem is they both are limited to only 20 Columns.

I'd like to edit the .js to increase the number of columns.. can it be done?

I'm not sure as I said I tried with qWidth but did not work.

The script which you provided will generate numbers, which can also be done by just adding row() as Serial in middle of Script.

I want to increase the number of columns so that I can add more dimensions to the table. (In Qlik Sense)

thanks.

Re: Qlikview Chart

vinieme12 — Wed, 11 Jan 2017 14:43:05 GMT

Can you post a new thread in the Qlik Sense discussion group, also what you are trying to do is not related to the above post.

Re: Qlikview Chart

jujucts — Wed, 08 Mar 2017 15:23:43 GMT

Hi Vineeth

so smart !

congratulations!

juju