topic Re: How to do Column1=Column2 in set Analysis in QlikView

How to do Column1=Column2 in set Analysis

agni_gold — Sun, 12 Jul 2015 01:11:27 GMT

I am tring to write below expression , but it is npt working

=aggr(sum({<[Account Type]={"=[Entry Type]"}>}[ERP Amount])/1000000,[PL Parent Description])

sunny_talwar — Sun, 12 Jul 2015 01:15:09 GMT

Not sure if this will get you what you want, but try this:

=Aggr(Sum({<[ERP Amount] = {"=[Account Type]=[Entry Type]"}>}[ERP Amount])/1000000,[PL Parent Description])

agni_gold — Sun, 12 Jul 2015 01:54:30 GMT

I just want

select sum(Amount) from table1 , table2

where table1.Account_Type=table2.Entry_Type

for this sql query I have written above set expression.

sunny_talwar — Sun, 12 Jul 2015 01:58:59 GMT

Would you be able to share a sample?

robert_mika — Sun, 12 Jul 2015 05:34:20 GMT

Are you using this set on two tables in front end?

Are they already join or are they two loosely couple tables?

MK_QSL — Sun, 12 Jul 2015 06:39:26 GMT

little change... try this..

=SUM(Aggr(Sum({<[ERP Amount] = {"=[Account Type]=[Entry Type]"}>}[ERP Amount])/1000000,[PL Parent Description]))

sasiparupudi1 — Thu, 23 Jul 2015 04:41:45 GMT

Please post your application