Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to limit a column

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 advanceF or I.JPG

7 Replies
rittermd
Master
Master

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
Partner - Creator II
Partner - Creator II

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
Not applicable
Author

Thank You so much for your reply

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

MK9885
Master II
Master II

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
Not applicable
Author

Thank u so much

MK9885
Master II
Master II

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

ggijben
Partner - Creator II
Partner - Creator II

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"