Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sudhir0538
Contributor

How to select only values from a list box as a dimension in chart?

Hi all!

I am assigned to create chart for the total utilization of an equipment. Database contains equipment and total utilization hours field.

How do i select only the total hours used (a single value from the total utilization hours table for a particular equipment selected) field for a particular equipment.

Thanks in advance.

Sudhir.

1 Solution

Accepted Solutions
MVP
MVP

Re: How to select only values from a list box as a dimension in chart?

It is actually built-in functionality of QlikView - you can see it demonstrated here with the scenario you mention:

2015-10-17 #1.PNG

6 Replies
MVP
MVP

Re: How to select only values from a list box as a dimension in chart?

It would be much easier to help you if you explain your setting with some sample data and your expected outcome.

MVP
MVP

Re: How to select only values from a list box as a dimension in chart?

It is actually built-in functionality of QlikView - you can see it demonstrated here with the scenario you mention:

2015-10-17 #1.PNG

sudhir0538
Contributor

Re: How to select only values from a list box as a dimension in chart?

I want to create a chart for the equipment utilization (in hrs ) for a single day. DB contains equipment list and booking id's and equipment ids by using these i join the table to retrieve the utilization hrs which also also available in the db. Utilization hours are calculated in hrs and stored in db like 2,24,16 etc.. in integer format. While I am selecting it as a dimension in barchart how should i get the only integer value corresponding to the particular equipment.??

ahmar811
Contributor III

Re: How to select only values from a list box as a dimension in chart?

As for your Requirement these type of Report is called as Ad Hoc report

Ad-hoc report expression

Adhoc reporting in Qlikview

hope it will help you

sudhir0538
Contributor

Re: How to select only values from a list box as a dimension in chart?

Hello Petter

While I am trying to load the Qvd file which you have send it shows the error message like this. Please guide how to overcome this issue.

Thanks in advance.

Capture.JPG

ahmar811
Contributor III

Re: How to select only values from a list box as a dimension in chart?