Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aryanreddy
New Contributor II

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
Honored Contributor

Re: How to limit a column

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
Contributor II

Re: How to limit a column

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'

aryanreddy
New Contributor II

Re: How to limit a column

Thank You so much for your reply

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

Khan_Mohammed
Honored Contributor II

Re: How to limit a column

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'

aryanreddy
New Contributor II

Re: How to limit a column

Thank u so much

Khan_Mohammed
Honored Contributor II

Re: How to limit a column

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

gngijben
New Contributor III

Re: How to limit a column

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"


Community Browser