How to limit a column

[Anonymous]

I have a column called "F/I" in that column i have F and I as values I want to show only F values in one table and Only I value in one  table.

Thanks in advance

[rittermd]

You would use set analysis in each table.

One table would limit to value of 'F' and the other to value of 'I'.

Add a column to each table using below.

Something like count({<F/I={'F'}>} "some field to count here"

If I understand what you are asking.

[nsetty]

Something like below.....

MainTable:

LOAD *, [F/I]

FROM ......

FTable:

Noconcatenate

Load *, [F/I]

Resident MainTable

WHERE [F/I]="F"

ITable:

Noconcatenate

Load *, [F/I]

Resident MainTable

WHERE [F/I]='I'

[Anonymous]

Thank You so much for your reply

But that code is not working it is showing as expression error.

[MK9885]

Create 2 dimensions in back end or use below expression in front end as dimension

1. if(F/I='F',F) as F

2. if(F/I='I',I) as I

or use this in front end with out 'as'

[Anonymous]

Thank u so much

[MK9885]

If you found the answer, mark it as correct and close this post

[ggijben]

You have 2 options,

1: In the script editor:

if(F/I='F',F/I) as F

if(F/I='I',F/I) as I

And use both dimensions in your chart.

2: Use calculated dimensions in table

if(F/I='F',F/I)

if(F/I='I',F/I)

Make sure to deselect "show null values"