Making filter

[#1]

Hello Friends,

I would like to create a filter but I am facing a problem of making a filter,

1. I would like to create a category.

2. In the first table I have amount, that has to be calculated if < amount is called 'Credit', in the same table if the Number = 1 then 'Not in the Account' and the third that is in the second table total_Credit as 'Credit Received'

3. I have tried join, concatenate that gives worng result even i tried inline field as a filter that has also not making any sense on that.

Is anybody tell me how to create a filter that sould be a dynamic one.

Regards

Chriss.

[#2]

what i understand is that u want filter on some dimension having amounts <0 (Credit) and for which Number=1.

But i dnt understand what condition u want to test from 2nd table.

May be u cud explain more.

Anyhow u'll have to join the two table on a common field, take resident load & create a flag variable.

Regards

[#3]

Hi,

Thanks for your reply.

Is that any example of join the two table on a common field, take resident load & create a flag variable.

Regrads

Chriss

[sujeetsingh]

join(tebale name) load

.key field,

---

---

--,

set variable=vlaodtime

resident Table2;

[#5 · Accepted solution]

Table1:

Load * from first table;

left join(Table1)

Load * from second table;

Table2:

Load *,if(credit<0 and Number=1 and 3rd condition,1,0) as flagvariable resident Table1;

drop table Table1;

This shud give u a fair idea if nt exact idea abt what to do.

[#6]

Hi Qlik_techie,

The idea is really awesome, Now I understood on resdential load and joins.

Thanks for your help.

Regards

Chirss