topic Re: Macro to select data from two separate table in QlikView

Macro to select data from two separate table

Fri, 26 Aug 2011 18:08:54 GMT

Hi Friends,

It's been a long time.

I recently came up with one situation, that I had to use two different table to bring data into one chart and

those tables are not connected.

In table A I have a field called FACT_TYPE(renamed as FACT_TYPE_A) and in table B I have a FACT_TYPE(renamed as FACT_TYPE_B).

I have attached a sample application, could you please refer to that.

What I need is a macro code that will select FACT_TYPE value from both table. Otherwise I had to select manually from both tables.

Many a thanks beforehand,

Regards,

Bikash Debnath

Fri, 26 Aug 2011 20:23:17 GMT

Hi Everyone,

I tried to solve it this way. I have attached the solution with a sample qvw application.

But I still have another problem, when I do a selection, I am not able to get the Total Sum bar.

Can anyone please help me.

Thanks,

Bikash

johnw — Fri, 26 Aug 2011 20:40:27 GMT

Quick and dirty answer:

sum(aggr(
if(B_FACT_TYPE='$(vCurrValue)', sum(B_PRICE), if(len(GetCurrentSelections(B_FACT_TYPE))=0, sum(B_PRICE)))
,B_PART_NO))

Now, why DID you rename your FACT_TYPE field in your two tables? Why don't you want to connect them?

Also note that your approach only gives answers when no or a single A_FACT_TYPE are selected. If you select more than one, it fails.

Fri, 26 Aug 2011 20:44:03 GMT

Hi John,

Thanks for your prompt response.

The reason why I didn't join FACT_TYPE is because the other details(dimensions) doesn't contain related data.

Only the FACT_TYPE field values are same in both cases. Hence I need both FACT_TYPE only for selection purpose.

thanks,

Bikash Debnath