topic Re: Making filter in QlikView

Making filter

Mon, 17 Dec 2012 14:11:18 GMT

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.

Re: Making filter

Mon, 17 Dec 2012 14:16:20 GMT

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

Re: Making filter

Tue, 18 Dec 2012 05:27:31 GMT

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

Re: Making filter

sujeetsingh — Tue, 18 Dec 2012 05:35:34 GMT

join(tebale name) load

.key field,

---

--,

set variable=vlaodtime

resident Table2;

Re: Making filter

Tue, 18 Dec 2012 07:26:10 GMT

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.

Re: Making filter

Tue, 18 Dec 2012 12:24:28 GMT

Hi Qlik_techie,

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

Thanks for your help.

Regards

Chirss