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: 
klrameet
Contributor III
Contributor III

Column manipulation, to display row total in column for the matches column data

Hi

So, I have this data and situation as shown below

I am trying to achieve is .. exhibit 3, where I want to

     1. remove the rows for AA

     2. Try to put the total for AA in columns, where the levels match.

Capture2.JPG

Appreciate your inputs.

8 Replies
klrameet
Contributor III
Contributor III
Author

I even tried to If(not Match(Type, 'AA'), Type) .. but then it just ignores the those rows and displays data something like as:


 

TypeLvl1Lvl2TotalAA
FRFC2081000
TIFC2081010
FFFC2081020
FRBD5051030
TIBD5051040
FFBD5051050
FRCT7101060
TICT7101070
FFCT710108

0

vegar.lie.arntsenagigliottizhandos_shotan

Vegar
MVP
MVP

It looks to me that your AA row is an aggregation of other rows in your table. Am I correct?

If so you don't need to create them, QlikView can calculate the totals for you.

Remove the AA row and try using  the expression Sum(TOTAL <Type> Total)

klrameet
Contributor III
Contributor III
Author

This is the data I get from the source, I am not aggregating them manually

Vegar
MVP
MVP

I see, then you could try this.

Load *

From ...

Where Type <> 'AA'

;

LEFT JOIN

LOAD

Lvl1,

Lvl2,

Total as AA

From ...

Where Type = 'AA'

;

klrameet
Contributor III
Contributor III
Author

No way to handle that on table/column .. cause I would not  have much control on data load ?

Vegar
MVP
MVP

I'm sorry, I didn't understand your last comment .

Did you find issues with my last suggestion using join?

klrameet
Contributor III
Contributor III
Author

i mean I don't have control over data load part, so I am not able to write script for data loading. Instead mandate is to work within app to manipulate columns

Vegar
MVP
MVP

I would ask the data manager if the AA is in fact the aggregated sum of all other Types. If the answer is yes then you could use the following expression. Sum({<Type -= {'AA'}>}TOTAL <Type> Total)