Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have uploaded all the data using the Load Script.Now i have tried adding expression to the List Value, Table or Pivot Table.When i enter the Match condition in the Expression, the value donot filter. Can you please help.
An example:
I have Loaded CSV file having Deptno,DNAME and DLOC using the load script.now on the sheet i added List and on the expression, i added
=Match(Deptno,10).
The List value should show me only 10 but it doesnt. The same is the case if i used the expression in Straight Table, Table Box or PIVOT Table.
How do i filter the values using the above objects.
Please help.
Regards,
Paul
What is the data format for Deptno in your load script? If that's num() -> what you written so far should work
If Deptno is a text() - then you will have to pass the value accordingly as string value -> match(Deptno, '10').
If you didn't define the format during the load script, it's probably taking the source data format. But it might be worth assigning num() or text() manually.
Maybe try something similar to the example below:
Thank you but it is not working.
here i explain. I have uploaded all the data using the load script.on the main sheet i added a listbox and Table box.
On the list box i have select the trade flag ='T'. Now the table box shows all the records which belong to Trades.
i got the trade counts by each contract source. by adding an expression on the table box.
Here is the screen shot
The properties on Table box show as below
the expression for Filtering values based on DBTETY_LEID_L3_BK is as below
The results doesnt show only values for 35976 but it shows all as below.
Can someone please help
Regards,
Paul
In your expression you're passing the value of DBTETY_LEID_L3_BK as text (using ' ') where it looks like the format of that is number. That's the first thing.
What exactly you are trying to calculate? Do you want to have another count over the DBTETY_LEID_L3_BK = 35976? Maybe you can provide some sample data?