topic Need Suggestions in QlikView

Need Suggestions

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Need Suggestions

soniasweety — Thu, 26 Jul 2018 13:12:48 GMT

Any idea to do comparison of attached requirement?

Jyothish KC

marcowedel‌

balabhaskarqlik

Re: Need Suggestions

agomes1971 — Thu, 26 Jul 2018 13:20:28 GMT

Hi,

have you seen this:

Simple example on Comparative Analysis

HTH

André Gomes

Re: Need Suggestions

soniasweety — Thu, 26 Jul 2018 13:35:09 GMT

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

MarcoWedel — Thu, 26 Jul 2018 17:54:58 GMT

Hi,

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

thanks

regards

Marco

Re: Need Suggestions

jyothish8807 — Fri, 27 Jul 2018 06:02:27 GMT

Hi Sony,

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

Br,

Re: Need Suggestions

pintucs20 — Sat, 28 Jul 2018 05:08:27 GMT

Hi Sony,

Please try alternate state for comparative analysis.

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

Re: Need Suggestions

BalaBhaskar_Qlik — Sat, 28 Jul 2018 10:08:11 GMT

May be this:

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

Re: Need Suggestions

soniasweety — Sat, 28 Jul 2018 17:53:51 GMT

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?