Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

Need Suggestions

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

Tags (2)
8 Replies
soniasweety
Valued Contributor III

Re: Need Suggestions

Any idea to do comparison of attached requirement?

Jyothish KC

marcowedel

balabhaskarqlik

agomes1971
Valued Contributor II

Re: Need Suggestions

Hi,

have you seen this:

Simple example on Comparative Analysis

HTH

André Gomes

soniasweety
Valued Contributor III

Re: Need Suggestions

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 ?

Re: Need Suggestions

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
Honored Contributor II

Re: Need Suggestions

Hi Sony,

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

Br,

KC

Best Regards,
KC
pintucs20
New Contributor III

Re: Need Suggestions

Hi Sony,

Please try alternate state for comparative analysis.

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

balabhaskarqlik
Honored Contributor

Re: Need Suggestions

May be this:

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

soniasweety
Valued Contributor III

Re: Need Suggestions

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?