Row wise customized total in straight table.

[naushad786]

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?

[jagan]

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.

[naushad786]

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

[Anonymous]

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

A

B

Total1

C

D

E

Total 2

F

Total3

Hope This helps you,

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

Regards

Nitin

[naushad786]

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.

[naushad786]

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.

[Anonymous]

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

[naushad786]

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.

[Anonymous]

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

[naushad786]

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.