4 Replies Latest reply: Apr 5, 2018 2:10 AM by Ashik Khan

# How to get Calculation in Rows

Hi Experts,

I need to calculate the following in rows (normally we do calculations in columns)

Jobs              140

Completed      120

Open              20

Efficiency       16.7  (Calculation (20/120)*100)

The above calculation i can get in columns, Need to calculate the same in ROWS.

Thanks,

MAK

• ###### Re: How to get Calculation in Rows

Hi,

You can use the ValueList function.

1st. Create a Dimension like this :

=ValueList('Jobs','Completed,'Open','Efficiency')

and then an Expression like this :

if(ValueList('Jobs','Completed,'Open','Efficiency')='Jobs',

Sum(Jobs),

if('Jobs','Completed,'Open','Efficiency')='Completed',

Sum(CompletedJobs)....

• ###### Re: How to get Calculation in Rows

Hi,

But the purpose is not solved of getting the below calculation in dimension...

Efficiency       16.7  (Calculation (20/120)*100)

Thanks.

MAK

• ###### Re: How to get Calculation in Rows

an example as Excel or Qlik file would make this easier

Gerold

• ###### Re: How to get Calculation in Rows

Below is the sample data...

 Date / Period January-17 February-17 W1 W2 W3 W4 W5 W6 W7 W8 Jobs 15 10 11 12 22 14 19 11 Open 4 2 0 7 0 2 0 3 Completed 11 8 11 5 22 12 19 8 Efficiency (%) 73 80 100 42 100 86 100 73

Efficiency       73  (Calculation (11/15)*100)

Thanks,

MAK.