Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Is it possible to create a calculated value on a row?

Hi is it possible to create a calculated value on a row?

For example I have Sales, Costs1 and Costs2, is it possible to create the following:

                                                          Jan     Feb     Mar

Row n1: Sales

Row n2: Costs1

Row n3: Margin1 (Sales-Costs1)

Row n4: Costs2

Row n5: Margin2 (Margin1-Costs2)

Thanks!

Camilo Lund R.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Is it possible to create a calculated value on a row?

Remove the Group Dimension.

Create expressions

Sales:

sum({<Group={'Sales'} USD)

Cost1

sum({<Group={'Cost1'} USD)

Margin1:

sum({<Group={'Sales'} USD)-sum({<Group={'Cost1'} USD)

Cost2

sum({<Group={'Cost2'} USD)

Margin2

(sum({<Group={'Sales'} USD)-sum({<Group={'Cost1'} USD))-sum({<Group={'Cost2'} USD)

View solution in original post

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Is it possible to create a calculated value on a row?

Hi,

To display chart like this use Pivot table, use Month as Dimension and write expressions for Sales, Costs1, Margin1, Costs2 and Margin2. 

No drag the Month dimension along to the top of the table and drag expressions to vertically. 

If possible, can you attach a sample file.

Hope this helps you.

Regards,

Jagan.

Highlighted
Contributor III
Contributor III

Re: Is it possible to create a calculated value on a row?

Hi Jagan,

Im attaching an example hoppfully it will be more clear.

The idea would be to create a margin1 between Cost1 and Cost2 and a margin2 at the bottom.

Margin1=Sales+Cost1

Margin2=Sales+Cost1+Cost2

Thanks,

Camilo

Highlighted
Contributor III
Contributor III

Re: Is it possible to create a calculated value on a row?

If I´m not beeing clear enough please tell me.

Thanks,

Camilo

Highlighted
Not applicable

Re: Is it possible to create a calculated value on a row?

Remove the Group Dimension.

Create expressions

Sales:

sum({<Group={'Sales'} USD)

Cost1

sum({<Group={'Cost1'} USD)

Margin1:

sum({<Group={'Sales'} USD)-sum({<Group={'Cost1'} USD)

Cost2

sum({<Group={'Cost2'} USD)

Margin2

(sum({<Group={'Sales'} USD)-sum({<Group={'Cost1'} USD))-sum({<Group={'Cost2'} USD)

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Is it possible to create a calculated value on a row?

Thanks it worked, it seems an >} was mising on the set analysis commands but it worked!

Highlighted
Not applicable

Re: Is it possible to create a calculated value on a row?

Oh, Yeah sorry about that. It has been a long day 😛