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: 
Not applicable

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

1 Solution

Accepted Solutions
Not applicable
Author

Hello my friends, I resolved my problem sequinte way:



LOAD * INLINE [

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.

View solution in original post

6 Replies
Not applicable
Author

hi,

sorry Not getting..buddy???

deepakk
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

Hello my friends, I resolved my problem sequinte way:



LOAD * INLINE [

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.