Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
hi,
sorry Not getting..buddy???
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
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
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.
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.
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.