6 Replies Latest reply: Aug 16, 2011 8:12 AM by williamcalsolari

# You can add lines to the QlikView ?

If someone can help me, I created the following script:

IF(NUM(ACCOUNT) = 31102140001, 'REVENUE 01',
IF(NUM(ACCOUNT) = 31102140002, 'REVENUE 02',
IF(NUM(ACCOUNT) = 31102180001, 'EXPENSES',
IF(NUM(ACCOUNT) = 31102190002, 'TAXES', )))) AS DRE,

each item that shows me in a row when I create a dynamic table in QlikView and sum total of them in the last line, I wonder if I can insert a row to make the sum of 01 and INCOME 02 REVENUES TOTAL REVENUES which would be called if can please help me.

Thank you,

William

• ###### You can add lines to the QlikView ?

hi,

sorry Not getting..buddy???

• ###### You can add lines to the QlikView ?

hi,

To get total Revenue , you have create anothe group like

IF(NUM(ACCOUNT) = 31102140001 or NUM(ACCOUNT) =31102140002, 'Total Revenue',
IF(NUM(ACCOUNT) = 31102180001, 'EXPENSES',
IF(NUM(ACCOUNT) = 31102190002, 'TAXES', )))AS MainGroup,

Now add this MainGroup Field in the dimension.

I hope this helps.

Deepak

• ###### You can add lines to the QlikView ?

Hello Deepak,

Thanks for the suggestion, it works but another problem arose I need to take the total revenue minus the taxes and make another line with the name of Net Revenue, you know how I do it?

Thanks,
William

• ###### You can add lines to the QlikView ?

HI,

Deepak here. My ID got blocked.

In such case you have to create only expression and no dimensions.

First Expression will have IF(NUM(ACCOUNT) = 31102140001, Revenue)

Second expression will have if(NUM(ACCOUNT) =31102140002, Revenue)

Third Expression will be column(1) + column(2). i.e your total revenue.

and so on,

Once you create all expressions. Drag the expression into row format.

I hope this helps.

• ###### You can add lines to the QlikView ?

Hi,

I think you are trying to develop an advacned P&L (Profit and Loss) report but which requires some advanced concepts that you can get if you undergo standard qlikview training. Otherwise little tricky to get P&L reports in qlikview.

Cheers.

• ###### You can add lines to the QlikView ?

Hello my friends, I resolved my problem sequinte way:

ACCOUNT, NAME,

31102140001,REVENUE 01

31102140002,REVENUE 02

31102180001,EXPENSES

31102190002,TAXES

31102140001,TOTAL REVENUE

31102140002,TOTAL REVENUE

];

A hug to everyone who helped me.