topic Re: Merging 2 Charts Into 1 in QlikView

Merging 2 Charts Into 1

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

Hi, everyone.

Can I combine this 2 charts into only 1 chart ?

The Jumlah Report chart will be embedded into Status chart as a new bar (it's already in the same date each other).

Here's the pict :

Can anyone teach me the way how to do this ?

Thank you.

- Kevin

Re: Merging 2 Charts Into 1

qlikviewwizard — Wed, 04 Jul 2018 06:33:18 GMT

Hi,

Please check 'Combo chart'.

It will suitable to your requirement.

Re: Merging 2 Charts Into 1

rmdnkevin — Wed, 04 Jul 2018 06:56:27 GMT

Thank you for the response.

In the other case, can I make the Jumlah Report as a new status ? As same as the Submitted Data, Email Sent, etc

Re: Merging 2 Charts Into 1

qlikviewwizard — Wed, 04 Jul 2018 06:58:04 GMT

Can you attach some sample data.

Re: Merging 2 Charts Into 1

rmdnkevin — Wed, 04 Jul 2018 07:02:54 GMT

Like this : (in this chart, assume the Jumlah Report chart as the Emails Reported bar)

Re: Merging 2 Charts Into 1

qlikviewwizard — Wed, 04 Jul 2018 07:46:49 GMT

Where is your source data? It is challenging the folks without data and asking for solution.

Re: Merging 2 Charts Into 1

ramzi-manoubi — Wed, 04 Jul 2018 07:56:49 GMT

measure 1 = sum(Jumlah report)

measure 2 = Count({<Status = 'Submitted Data'>} X)

measure 3 = Count({<Status = 'Email Sent'>} X)

measure 4 = Count({<Status = 'Clicked Link'>} X)

measure 5 = Count({<Status = 'Email Opened'>} X)

Dimension = Date

Re: Merging 2 Charts Into 1

rmdnkevin — Wed, 04 Jul 2018 08:03:33 GMT

Here you are

So sorry if it's too much for you

Re: Merging 2 Charts Into 1

sasikanth — Wed, 04 Jul 2018 10:05:58 GMT

Try

count( {<Status={'Submitted Data'}>} Status)

count( {<Status={'Email Opened'}>} Status)

count( {<Status={'Clicked Link'}>} Status)

count( {<Status={'Email Sent'}>} Status)

Sum(DISTINCT [Emails Reported])

attached app for reference

Re: Merging 2 Charts Into 1

rmdnkevin — Wed, 04 Jul 2018 13:50:27 GMT

Thank you so much everyone for the whole responses