topic Re: add two dimension and expression in one graph in QlikView

add two dimension and expression in one graph

Mon, 26 Jan 2026 18:19:17 GMT

Hi ,

I want to create graph where in i want to show two dimensions and expressions.

Employee not completing 8 Hrs and Dept not completing 8 hrs with percentage.

Dept whose 8 hrs percentage will less than 20%, Must be in Red same way more than 20% will be in Yellow. and more than 50% in Green.

Can i show it is same graph.

Please suggest.

I have attached the data.

DEPT_NO DEPT_NAME

1 Chairman

101 HR

102 IT

103 Inspector

120 Finance

121 Quality

Thanks and Regards,

Re: add two dimension and expression in one graph

Mon, 23 Nov 2015 11:57:36 GMT

Please assist me on this

Re: add two dimension and expression in one graph

Anonymous — Mon, 23 Nov 2015 12:04:44 GMT

When it comes to:

1 Expression and 2 dimension

2 Expression and 1 Dimension...

Scatter/Grid Chart are the best options..

Re: add two dimension and expression in one graph

Mon, 23 Nov 2015 12:09:38 GMT

Hi Balraj,

Thanks...

I am looking for the expression where employees are not completing 8 hrs. If the percentage is less than 20%, it should be in RED color and where above should be green please help me writing the expression for the same.

Re: add two dimension and expression in one graph

Mon, 23 Nov 2015 12:40:11 GMT

Hi Shaikh,

You have any idea to convert time into percentage.

how to find 20% of 8 hours

Re: add two dimension and expression in one graph

vishsaggi — Mon, 23 Nov 2015 12:50:09 GMT

Hi raman,

It is same mathematical expression you need to do for 20% of 8

(20/100) * 8 = 1.6hrs...Hope this helps..

Thanks,
V.

Re: add two dimension and expression in one graph

santhosh_k_n — Mon, 23 Nov 2015 13:10:18 GMT

Hi,

Can u clarify the following points,

1. do u want to present both the dimensions at a time?

2. if yes which type of graph u want to use in ur presentation

Re: add two dimension and expression in one graph

Mon, 23 Nov 2015 13:15:21 GMT

Hi,

i think this is hepfull for u

Expression:

=if(TOT_DUR<Interval(0.50 * Time('8', 'h')/24, 'hh:mm:ss'),red(),

if(Interval(0.50 * Time('8', 'h')/24, 'hh:mm:ss')>TOT_DUR,yellow(),Green()))

Re: add two dimension and expression in one graph

Mon, 23 Nov 2015 13:19:57 GMT

You did not get my point here suppose every day employees are going to office, They have to complete 8 hrs. Sometime they go early. percentage i can find out by using below expression

Count(TOT_DUR)>='08:00'/Count (TOTAL TOT_DUR)*100

Now i am getting a percentage now i don't know how to get get a different colour for different percentage.

I want to show dept and emp percentage with color on the same graph.

Hope this help.

Re: add two dimension and expression in one graph

Mon, 23 Nov 2015 14:19:08 GMT

I am trying to show the employees whose percentage is less than 20% must be green colour.

I am using the below expression to get the count of employees completing completing 7 Hrs.

count({1<TOT_DUR={'>=07:00'}>} TOT_DUR)

for percentage, I have to divide by total(TOT_DUR)

count({1<TOT_DUR={'>=07:00'}>} TOT_DUR)/count(TOTAL TOT_DUR)

I have attached the screenshot. I am using Pivot table. But i want to show the same with percentage and with colour on other graph like grid graph one which is suggested by Balraj.

Thanks

Re: add two dimension and expression in one graph

thomaslg_wq — Mon, 23 Nov 2015 14:36:16 GMT

Hi,

you can also add this inline load :

LOAD * INLINE [

dimension

Departement

Employe

];

And then in you chart, you can use these two separated dimensions :

Re: add two dimension and expression in one graph

Wed, 25 Nov 2015 15:56:14 GMT

finally i have got the correct percentage to display on pivot table.

Please assist me how to display the same on graph where employees percentage is less than or equal to 20

should be display in RED and above 20% Yellow and 40% green in guage graph or any other graph with employees/

Thanks