Need Suggestions

[soniasweety]

Hi all,

i have  3data tables coming from single data source.

Database tables :

DA_Table1

DB_Table2

DC_Table3

so  the result table they want to  compare the   three sources  Deals based on ID   

so how can  i represent the table for comaprision ?    if i go with id's in month number of ids will be there so for 3 tables how can i compare and show?     

can anyone give me the better way to do this report?    requirment is attached

Thanks

Sony

[soniasweety]

Any idea to do comparison of attached requirement?

Jyothish KC

marcowedel‌

balabhaskarqlik

[agomes1971]

Hi,

have you seen this:

Simple example on Comparative Analysis

HTH

André Gomes

[soniasweety]

Thanks.  But i dont feel here it is required ?  means alternate states will not help me i think  

is there any other way to represent ?

[MarcoWedel]

Hi,

can you post some sample data for your three tables as well as your required result based on this data?

thanks

regards

Marco

[jyothish8807]

Hi Sony,

As Marco mentioned, a sample data would be helpful to look into this

Br,

KC

[pintucs20]

Hi Sony,

Please try alternate state for comparative analysis.

Setting->>Document Properties->>General Tab-->>Alternate State

[balabhaskarqlik]

May be this:

Rangemax(Sum({<[Grand Total]=>}NID),Sum({<[Total HCV]=>}NTTID),Sum({<HDR=>}SSID))

[soniasweety]

Hi Thanks,

I need to build the  same table in qlikview 

for 3 tables same measures  but diffent tables so  alternate states will not work here I think ?

so can you give better idea to show that table?