Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

creating charts

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.

  

5 Replies
berkarmagan
Partner - Creator
Partner - Creator

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

Not applicable

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?

srujanaponnuru
Creator
Creator
Author

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.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

What is expression for it ?

Not applicable

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