topic Re: An interesting scenario in QlikView

An interesting scenario

Wed, 19 Mar 2014 04:09:44 GMT

I have the data like this. Employee id, their home location and work location

Employee Home Work

101 A B

102 A C

103 A A

104 C B

105 C C

106 B A

I need a graph like this. Is this possible?

Work WorkCount HomeCount

A 2 3

B 2 1

C 2 2

Re: An interesting scenario

Anonymous — Wed, 19 Mar 2014 04:40:09 GMT

PFA

Re: An interesting scenario

qlikpahadi07 — Wed, 19 Mar 2014 05:19:11 GMT

Hi Ram Kumar,

PFA with Front end

Re: An interesting scenario

jagan — Wed, 19 Mar 2014 05:27:08 GMT

Hi,

Check this script

Temp:

LOAD

INLINE [

Employee, Home, Work

101, A, B

102, A, C

103, A, A

104, C, B

105, C, C

106, B, A];

Data:

LOAD

Employee,

Home AS Location,

'Home' AS LocationType

RESIDENT Temp;

Concatenate(Data)

LOAD

Employee,

Work AS Location,

'Work' AS LocationType

RESIDENT Temp;

Now in chart,

Dimension : Location

Expressions:

Home Count : count({<LocationType={'Home'}>} Employee)

Work Count: count({<LocationType={'Work'}>} Employee)

Regards,

Jagan.

Re: An interesting scenario

Wed, 19 Mar 2014 05:52:36 GMT

TThanks Jagan. But I can't touch the script, need to do this somehow in the front end.

Re: An interesting scenario

qlikpahadi07 — Wed, 19 Mar 2014 05:59:29 GMT

Did you saw my attachment I have done that in front end

Re: An interesting scenario

Wed, 19 Mar 2014 06:05:18 GMT

Not yet. Cant open attachments now because of restrictions. Accessing this thread by phone

But can open after 2 hrs

Sent from my iPhone

Re: An interesting scenario

kumarnatarajan — Wed, 19 Mar 2014 06:17:36 GMT

Hi,

Try Below one

Dimention :

=if($Field='Work',Work,if($Field='Home',Home))

Expresions:

Home

Count(if($Field='Home',Home))

Work

Count(if($Field='Work',Work))

Re: An interesting scenario

Thu, 20 Mar 2014 03:53:13 GMT

Can't afford to do this as the data I show here is just a sample

Re: An interesting scenario

Thu, 20 Mar 2014 03:54:08 GMT

Thanks Nitin but I'm actually looking to do something at the front-end level

Re: An interesting scenario

Thu, 20 Mar 2014 03:54:54 GMT

Sorry Kumar, this didn't work

Re: An interesting scenario

qlikpahadi07 — Thu, 20 Mar 2014 05:17:47 GMT

let me know if that was helpful

Re: Re: An interesting scenario

kumarnatarajan — Thu, 20 Mar 2014 07:23:22 GMT

Hi Ram,

PFA. It's working fine