topic Re: Chart in QlikView

Chart

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

Hi,

My chart uses only expressions.

In my chart, I want to display a Mini Chart that will show the average number of leads by selected day.

Is it possible to build a table with the following columns:

1. will display the number of leads,

2. will display the number of leads only to source 'Email',

3. will display the number of leads only to source 'online',

3. will display a Mini Chart showing the average number of leads by selected day

Attached is a picture of the Mini Chart i want to display

Re: Chart

sunny_talwar — Thu, 10 Aug 2017 11:02:28 GMT

What are you planning to use as your dimension here?

Re: Chart

ttal7878 — Thu, 10 Aug 2017 11:17:18 GMT

I don't want to use dimension.

the expressions will be on the Y axis.

There is an option to build such a table?

Re: Chart

sunny_talwar — Thu, 10 Aug 2017 11:25:55 GMT

Something like this?

Re: Chart

ttal7878 — Thu, 10 Aug 2017 11:36:08 GMT

No,

in the QVW attached, there is an 'Incoming Report' chart, I want to add another column that will display the Mini Chart

is it possible?

Re: Chart

sunny_talwar — Thu, 10 Aug 2017 11:40:45 GMT

I have not done this before, but hopefully someone else can help.

Re: Chart

MayilVahanan — Thu, 10 Aug 2017 11:59:36 GMT

In pivot table, we can't able to create Mini chart.

Re: Chart

effinty2112 — Thu, 10 Aug 2017 12:12:45 GMT

Hi Tal Tal,

You can make a straight table like this:

Add a dimension : 1 (just the number one) and hide this column

Add your measures of choice. Make mini charts on the dimension date. Make totals mode No Totals.

In the presentation tab check the Horizontal box.

Good luck

Andrew

Re: Chart

ttal7878 — Thu, 10 Aug 2017 12:46:08 GMT

can You attach an example?

Re: Chart

vinieme12 — Thu, 10 Aug 2017 13:13:04 GMT

check attached

Re: Chart

vishsaggi — Thu, 10 Aug 2017 14:57:43 GMT

Hello Tal,

If your question is answered can you close the thread marking correct/helpful responses.

Thanks,
V.