Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have two separate fields called "Customer" and "Suppliers"
The table logic is if the Customer Name is blank then there will be a supplier name filled and vice versa
Now I need to create a list box or a field where I want to show Type ie.Customer,Supplier and then after the selection the data needs to be refreshed based on that.
Kindly help me
Thanks & Regards
Jeba
Hi, look at the attachment.
Below code will do the work.
If(len(trim(Customer))=0,'Supplier','Customer') as Filter
Regards
ASHFAQ
If(IsNull(Customer),Supplier,Customer)
On what basis you are going to provide supplier name or Customer name even if its blank.
Can you post some sample data???
Is it a single fact table or different dimension tables??
Please elaborate..........
Regards
Nitin
Hi Anbu,
Thanks for the reply.
However,this is listing the names of the Customers and Suppliers,but what I want to show in the list box is only two manual fields like below
Customer
Supplier
When user select "Customer" my table has to filter only the "Customer data" and vice versa
Kindly help
Thanks & Regards
Jeba
Can you attach sample app
Hi Nitin,
These two are separate fields in a same table
Regards
Jeba
Hi,
may be like this
If(len(trim(Customer))=0,Supplier,Customer)
Regards
ASHFAQ
OK I got your point.....
First of all Use inline load for Customer and supplier...
Load * inline[
Field_Category
Customer
Supplier
];
Now create the list box of Field_Category at fron t end.
Now in your chart, provide Customer and Supplier bothin dimensions and provide the enable condition for both as
Customer >> if(getselectedcount(Field_Category)=1 and GetFieldSelections(Field_Category)='Customer',1,0)
Supplier >> if(getselectedcount(Field_Category)=1 and GetFieldSelections(Field_Category)='Supplier',1,0)
Hope this will help you.
If required you can post your sample qvw...
Regards
Nitin
Hi Anbu,
Please find attached the sample data.
Thanks & Regards
Jeba
Hi, look at the attachment.
Below code will do the work.
If(len(trim(Customer))=0,'Supplier','Customer') as Filter
Regards
ASHFAQ