Solved: How to filter one column based on another when cre... - Qlik Community

Anonymous · ‎2012-09-06

Hi Folks,

Say, I have a table like this:

COL1	Visible
1	yes
2	yes
3	no
4	no
5	yes

Normally I can create 2 fields: COL1 and Visible. COL1 shows all values (1,2,3,4,5) and Visible shows 'yes' and 'no'.

When I select 'yes' in 'Visible' manually, 1 2 5 will be white in COL1 and 3 4 will be greyed out.

But how can I create COL1 field with a condition so that it can by default show only 1 2 5 without having the user manually selecting 'yes'? (In this case I don't need to create the 'Visible' field at all)

Is it possible doing so without creating new tables?

I am aware there is a "conditional" checkbox in every field's Properties - Expressions tab. Is it the right place to look at? How to write the condition?

Thanks,

Jeremy

rajni_batra · ‎2012-09-06

u wrote the expression in expression tab of list box that's wrong use it in general tab of List Box (attached screenshot ) or create a Straight or pivot table & then wriite d same expression there inexpression tab.

Hope this Help

View solution in original post

rajni_batra · ‎2012-09-06

DO u want to Display COL1 only for those whose visible selection is :'yes'??

Anonymous · ‎2012-09-06

Yes exactly.

Sorry I didn't describe this clearly.

daveamz · ‎2012-09-06

Hi,

It is possible with set analysis (see the file attached).

Regards,

David

rajni_batra · ‎2012-09-06

this is simple then use expression if(visible='yes',col1)

Anonymous · ‎2012-09-06

Adding to my original question, considering I have another table with the one above:

COL1	COL2
1	A
2	B
3	C
4	D
5	E

These 2 tables will be connect by column COL1.

I also want to create a select field that only shows A B E from COL2. That is, it filters the 2nd table's row based on a colume in the 1st table.

Is it possible?

Thanks.

Jeremy

Anonymous · ‎2012-09-06

Do you mean adding a expression in the "Expressions" Tab?

I tried, but the result looks very strange. It shows 2 columns. One is 1 2 3 4 5, the other is 1 2 - - 5.

Please check the screenshot:

Any idea?

Thanks

Anonymous · ‎2012-09-06

Thanks for replying but my personal edition cannot open any QVW from other source anymore

Can you explain your solution by words?

Thanks

rajni_batra · ‎2012-09-06

see the scrrenshot

Anonymous · ‎2012-09-06

Thanks. It looks great!

Can you explain a bit more by words? I am not that familiar with QV now. By looking at the screenshot I can't figure out how did you do it.

Thanks.

How to filter one column based on another when creating a select field?