topic Re: Row wise customized total in straight table. in QlikView

Row wise customized total in straight table.

naushad786 — Fri, 06 Dec 2013 11:25:19 GMT

There is any solution to do customized total in straight table.

Straight table provide the total of all columns that exist by default, but my need is do the total condition wise. Can anyone help?

Re: Row wise customized total in straight table.

jagan — Fri, 06 Dec 2013 11:32:29 GMT

Hi,

Try this condition in expression

If(RowNo() = 0, You Conditional expression, Sum(MeasureName))

-- RowNo() = 0 is for Total

Hope this helps you.

Regards,

Jagan.

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 04:07:10 GMT

Dear Jagan,

I am using straight table and I want to do customized total row wise so how can do this.

Where I have to write condition. I am not able to find that location where I have to write condition.

This is qlikview 11.

Thanks & Regards,

Naushad Ali|SMR Team|MothersonSumi INfotech & Designs Limited|9990558279

Re: Row wise customized total in straight table.

Anonymous — Mon, 09 Dec 2013 05:49:31 GMT

HI Naushad,

You can define a calculated dimension ,

Example:

chart shows a measure based on dimension1

and Dimension 1 consists of values A,B,C,D,E,F.

Now suppose you want totals as Total1=A+B, Total 2=C+D+E, Total 3=F,

In script> load Dimension1,* from table;

Concatenate

load

if(Dimension1='A' or Dimension1='B','Total 1',

if(Dimension1='C' or Dimension1='D' or Dimension1='E','Total 2','Total 3')) as Dimension1,*

from Table ;

Now in chart when you will have dimension1 as dimension, your conditional totals can be shown.

Moreover you can sort your data accordingly as

Total1

Total 2

Total3

Hope This helps you,

Otherwise, post a sample, I can show you....

Regards

Nitin

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 06:26:00 GMT

Dear Nitin,

Thanks for reply but I think this is not correct solutions that I need.

I am attaching new screenshots that what is my need.

Please go through.

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 06:26:59 GMT

Dear Nitin,

Thanks for reply but I think this is not correct solutions that I need.

I am attaching new screenshots that what is my need.

Please go through.

Re: Row wise customized total in straight table.

Anonymous — Mon, 09 Dec 2013 06:33:11 GMT

Hi Naushad ,

If I am correct, I dont think this format of report can be achived in Straight table, why not you use a pivot table,

In Pivot your requirement can be easily fulfilled.

Regards

Nitin

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 06:44:50 GMT

Dear Nitin,

Actually in Pivot table there is not option to show data horizontally. that is the reason that i am using straight table.

my need is dimension will always on top not in left side. if i can achieve this thing in pivot table so there is no issue i will use pivot table. please help.

Re: Row wise customized total in straight table.

Anonymous — Mon, 09 Dec 2013 06:50:19 GMT

Create a Pivot Chart with the data and

drag the week dimension to the top of expression and drag all expressions to left side and resulting table would be of your requirement.

If you will post a sample , I can easily show you.

Regards

Nitin

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 07:07:30 GMT

Like this. but but this is not actual format that i need. on top should be 6 dimensions like 44 , 45, 46, 47, 48 & MTD.

Re: Row wise customized total in straight table.

Anonymous — Mon, 09 Dec 2013 07:10:17 GMT

Hi Naushad,

Just try to drag week dimension to the top of the columns, and you will definately get your formt.

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 07:19:06 GMT

Nitin thanks. now the format is same which i need. but how can i do the condition wise total in last row.

Re: Row wise customized total in straight table.

kiranmanoharrode — Mon, 09 Dec 2013 07:24:00 GMT

Dear Naushad,

can u post the sample application??? it will be helpful to understand and solve your problem.

Re: Row wise customized total in straight table.

Anonymous — Mon, 09 Dec 2013 07:24:15 GMT

Try Subtotals in Presentation Tab of properties of the chart object

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 07:35:24 GMT

Dear Kiran,

Re: Row wise customized total in straight table.

naushad786 — Mon, 09 Dec 2013 09:12:52 GMT

i want to do subtotal condition wise. is it possible?..

Re: Row wise customized total in straight table.

Anonymous — Tue, 10 Dec 2013 13:52:17 GMT

On what conditions you want the totals.

Actually, we can do a subtotal only based on dimension values , therefore you are able to sum up the week values.

If some conditions are to be applied, we have to have more dimension for that.

Please tell me on what condition you need totals.

Regards

Nitin

Re: Row wise customized total in straight table.

naushad786 — Wed, 11 Dec 2013 03:17:35 GMT

Like this

Re: Row wise customized total in straight table.

Anonymous — Wed, 11 Dec 2013 07:44:47 GMT

If this type of conditions will be applied, so I think you will be having multiple MTD column,

as you want to sum up Budget and Forecast for week 44,

and others also...

I think it would not be possible.

One solution can be , you can use text boxes for showing specific totals.