Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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
join(tebale name) load
.key field,
---
---
--,
set variable=vlaodtime
resident Table2;
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.
Hi Qlik_techie,
The idea is really awesome, Now I understood on resdential load and joins.
Thanks for your help.
Regards
Chirss