An interesting scenario

[#1]

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

[Anonymous]

PFA

[qlikpahadi07]

Hi Ram Kumar,

PFA with Front end

[jagan]

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.

[#5]

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

[qlikpahadi07]

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

[#7]

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

But can open after 2 hrs

Sent from my iPhone

[kumarnatarajan]

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))

[#9]

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

[#10]

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