topic Re: How to show this in chart in QlikView

How to show this in chart

Anonymous — Wed, 03 Dec 2014 08:37:08 GMT

Hi All,

I am having following requirement. In my 3 tables 9Customers,Service & Versions) I need to show this Customer performing this Service using this Version.

As I need to show data as it is , the aggr functions may not required

Re: How to show this in chart

mato32188 — Wed, 03 Dec 2014 08:48:54 GMT

Hi,

is there any association between tables you mentioned?

Re: How to show this in chart

Anonymous — Wed, 03 Dec 2014 08:52:14 GMT

My Data will Look like Below

Customers:

CUST Service

A1 S1
A2 S2

A3 S1

Service:

Service Version

S1 1.0
S2 1.0

Version:

Ver Desc
1.0 ALL

2.0 PVT

3.0 IT

Re: How to show this in chart

srdheekonda — Wed, 03 Dec 2014 09:21:49 GMT

Rename Ver column to Version in Version table. So that it will create a Join with Version column in service table.

Find below the sample script and table join diagram. Once the join created you can filter the data accordingly.

Customers:
LOAD * INLINE
[CUST,Service
A1,S1
A2,S2
A3,S1];

Service:
LOAD * INLINE
[Service,Version
S1,1.0
S2,1.0];

Version:
LOAD * INLINE
[Version,Desc
1.0,ALL
2.0,PVT
3.0,IT];

I hope this helps

Re: How to show this in chart

mato32188 — Wed, 03 Dec 2014 09:24:33 GMT

Just rename your Ver field by Version and create table with your desirable fields.

Re: How to show this in chart

Anonymous — Wed, 03 Dec 2014 09:31:53 GMT

Hi Martin & Sampath,

Thanks for your help. I am looking for, how to show the values in desired manner. I already completed my data modeling. Now I need to show above requirement in a graph. That is what I asking.

-Jay

Re: How to show this in chart

mato32188 — Wed, 03 Dec 2014 09:43:23 GMT

Create bar chart with customer, service dimensions and count Version. Is that what are you looking for?

Re: How to show this in chart

Anonymous — Wed, 03 Dec 2014 09:58:53 GMT

Hi Martin,

you are right, But thing is I don't want to Count anything. Because counting the version is not meaning full here.

Re: How to show this in chart

mato32188 — Wed, 03 Dec 2014 10:09:31 GMT

Attach your data sample, please. Would be better.

Re: How to show this in chart

Anonymous — Wed, 03 Dec 2014 10:18:28 GMT

Hi Martin,

I cant attach data due to restrictions. All I need is your idea/Suggestions. So kindly let me know

Re: How to show this in chart

Anonymous — Wed, 03 Dec 2014 11:36:56 GMT

Any Better ideas?

Re: How to show this in chart

Wed, 03 Dec 2014 11:40:52 GMT

What are you need to show? Try add Table box with all your fields: Cust, Service and Version.

Re: How to show this in chart

Anonymous — Wed, 03 Dec 2014 11:44:19 GMT

Hi Alex,

Yes I can do that, But it would be good if I provide any pic representation.

Re: How to show this in chart

Wed, 03 Dec 2014 12:08:23 GMT

Maybe something like chart "Customers mix" here:

http://eu-b.demo.qlik.com/detail.aspx?appName=Insurance.qvw

Re: How to show this in chart

Wed, 03 Dec 2014 23:51:09 GMT

From what I'm reading, you need to display everything and then add dimensions by customer, service and versions, so you could add a Table Box, add the 3 dimensions and then just add 3 list boxes with each dimension.