topic Re: how to Compare two tables value? in QlikView

how to Compare two tables value?

narender123 — Thu, 14 Feb 2013 11:57:49 GMT

Hi All,

I have two tables suppose "Table A" with column "taxpair","taxno","Amount" and "Table B" with column "taxpair".I want to show the result like

if(taxno=1 and value of taxpair of table A is present in table B taxpair values then show "Individual"

but if(taxno=1 and value of taxpair of table A is not present in table B taxpair values then show "Individual-Enterprise"

?????????????

Thanks in advance.

Re: how to Compare two tables value?

narender123 — Thu, 14 Feb 2013 12:05:17 GMT

I have worked on it in script and script is executed well like

if(taxno=1 and taxpair=taxpair2,'Individual',

if(taxno=1 and taxpair<>taxpair2,'Individual-Enterprise'))

but in tablebox its doesn't show the individual ???

Here i have changed the column name of table B taxpair as taxpair 2.

Re: how to Compare two tables value?

manideep78 — Thu, 14 Feb 2013 12:29:44 GMT

pls give sample data

Re: how to Compare two tables value?

narender123 — Thu, 14 Feb 2013 12:53:46 GMT

Thanks for reply.

Manideep Its not possible to give you data because its reside on my production sever where i cant copy the data .i have written the all information just like table A and table B in my above question .So could you give me the suggestion?

Thanks.

Re: how to Compare two tables value?

narender123 — Fri, 15 Feb 2013 08:06:46 GMT

Have anybody suggestion for me????????????

Re: how to Compare two tables value?

manideep78 — Fri, 15 Feb 2013 08:56:32 GMT

Take Straight table instead of table box.

Check the attached qvw

hope it helps and let me know whether it is your requrired output or not??

Re: how to Compare two tables value?

narender123 — Fri, 15 Feb 2013 12:10:28 GMT

Thanks Manideep.

But if u see ur attachment then u will find there.. Taxpair=Taxpair2 not working and the result always shows the value for Taxpair<> Taxpair2.Means its not working for "=" sign between 2 tables and return the else part wherever that is..

I have already found this problem.But its not the solution.

Can you give me some other solution please.

Thanks.

Re: how to Compare two tables value?

manideep78 — Fri, 15 Feb 2013 13:03:44 GMT

Please find this

Re: how to Compare two tables value?

narender123 — Tue, 19 Feb 2013 09:30:58 GMT

Thanks Manideep.

In your qvw ,if we take all dimention its working but i take tax pair and amount dimention.Like this

Taxpair Amount

Individual 100000000

Individual_Enterprise 200000000

property 250000000

enterprise 1500000000

condition :1) taxno=1 and taxpair=taxpair2 then individual

2)taxno=1 and taxpair<>taxpair2 then individual-enterprise

3) taxno=2 then property

4) taxno=3 then enterprise

This is just like sample data.So now you can help me easily.

Thanks in advance.

Re: how to Compare two tables value?

Tue, 19 Feb 2013 09:45:33 GMT

Hi,

I would suggest a new idea:

Try to research alternate states.

With set analysis and states you can compare 2 kinds of tables. Let me know if you require an example document.

Kind Regards,

Dion

Re: how to Compare two tables value?

Tue, 19 Feb 2013 09:45:38 GMT

Hi,

I would suggest a new idea:

Try to research alternate states.

With set analysis and states you can compare 2 kinds of tables. Let me know if you require an example document.

Kind Regards,

Dion

Re: how to Compare two tables value?

narender123 — Tue, 19 Feb 2013 09:49:10 GMT

Yes .I need your help.So its better if you give me the example please.

Thanks.

Re: how to Compare two tables value?

Tue, 19 Feb 2013 10:10:04 GMT

Hi,

please try this expression instead

if(taxno=1 and taxpair=taxpair2,'indivdual',(if(taxno=1 and taxpair<>taxpair2,'individual-enterprise',if(taxno=2,'property',if(taxno=3,'enterprise'))))) as new

in the Mohit's qvw.

It's working fine as per your requirement.

Re: how to Compare two tables value?

narender123 — Tue, 19 Feb 2013 11:16:56 GMT

Hello Kumariysns,

I have done with your expression but its not working for taxpair=taxpair2.

See the attachment below.

Re: how to Compare two tables value?

Tue, 19 Feb 2013 14:12:23 GMT

Hi Narender,

It's working fine for me, plz check out the below attachments.

Re: how to Compare two tables value?

narender123 — Tue, 05 Mar 2013 07:35:13 GMT

Thanks Kumariysns..