topic Re: Chart Presentation in QlikView

Chart Presentation

vanderson009 — Thu, 10 Jul 2014 07:42:27 GMT

Hello Community,

I have sample data as like below.

LOAD * Inline [

TouchPoint, Date, ResponseNo

billing, 07/01/2014, 123

billing, 06/01/2014, 234

billing, 05/01/2014, 345

billing, 04/01/2014, 453

devices, 07/01/2014, 345

devices, 06/01/2014, 234

devices, 05/01/2014, 342

devices, 04/01/2014, 546

network, 07/01/2014, 466

network, 06/01/2014, 654

network, 05/01/2014, 456

network, 04/01/2014, 567

online, 07/01/2014, 345

online, 06/01/2014, 342

online, 05/01/2014, 245

online, 04/01/2014, 543

];

By using this data i want output as like Table 02 but by default i get out put as like Table 01.

-- Thanks in advance

Villyee

Re: Chart Presentation

ThornOfCrowns — Thu, 10 Jul 2014 07:52:43 GMT

What are the columns in Table02?

Specifically, what is the relationship of the single MonthName to your data - it isn't Max or Min - and what is that figure in brackets?

Re: Chart Presentation

vanderson009 — Thu, 10 Jul 2014 08:03:49 GMT

Hi James,

Thanks for your quick resonse.

My first column is TouchPoint, Second column is Monthname. i have four Months which are common

for each touch point and in bracket there is sum(Response) per Month.

Hope you understand.

-- Thanks

Villyee

Re: Chart Presentation

ali_hijazi — Thu, 10 Jul 2014 08:04:37 GMT

do you mean you want for billing show the sum of responseNo for min date available then for devices the next month and so on?

Re: Chart Presentation

MK_QSL — Thu, 10 Jul 2014 08:15:17 GMT

How billing is 2109?

devices 1388 coming?

Can you explain your logic pls?

Re: Chart Presentation

vanderson009 — Thu, 10 Jul 2014 09:23:13 GMT

sum of response is related to MonthName field, Which is not related to TouchPoint.

But if we click over any one of the touch point then respective touchpoint response per month

will come.

Thanks Manish, Hope you understand my reuirement.