topic Re: creating charts in QlikView

creating charts

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

I have two excel files

in book4 xls file I have three columns 1. Location 2. Office Hours (ET) 3. Application

and in other book5 xls file I have three columns 1. Location 2. # of Users 3. Application

I wrote a script to concatenate these two tables.

Data1:

Load Location,

[Office Hours (ET)],

Application;

Concatenate

Data2:

Load Location,

[# of Users],

Application;

Now I want the following requirement:

i want to see the “User Location” chart. i want to be able to click on/search a location on the chart and see which applications are associated with that location
i also want to see office hours by location.

please help me out.

Re: creating charts

berkarmagan — Tue, 20 Sep 2016 08:45:06 GMT

DATA: LOAD Location, [# of Users], Application from excel5; Concatanate LOAD Location, Office Hours (ET), Application from excel4; I think it works for u.

Re: creating charts

Tue, 20 Sep 2016 09:13:07 GMT

I guess location in the two tables means different things, one for user location and another for office location? If so, application column is used to join the two table, with which, it should be quite straight forward to check application or office hour according to filtered user location.

Could you describe the problem again? Are you trying to plot a map using user location?

Re: creating charts

srujanaponnuru — Tue, 20 Sep 2016 09:18:40 GMT

yes I need to plot a graph according to location, I have a list box application, when I click on application I have to see the number of users using that application with respect to location.

Below is the graph I need to plot the same.

and no idea how to show office hours according to location.

Re: creating charts

nagarjuna_kotha — Tue, 20 Sep 2016 09:38:57 GMT

What is expression for it ?

Re: creating charts

Tue, 20 Sep 2016 09:45:39 GMT

Since multiple office locations are linked to simple application, multiple office hour are expected. In that case, do you wanna show a list? ..