topic Re: How to filter one column based on another when creating a select field? in QlikView

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

Anonymous — Thu, 06 Sep 2012 04:23:01 GMT

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

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

rajni_batra — Thu, 06 Sep 2012 07:25:55 GMT

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

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

Anonymous — Thu, 06 Sep 2012 07:52:17 GMT

Yes exactly.

Sorry I didn't describe this clearly.

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

daveamz — Thu, 06 Sep 2012 07:53:58 GMT

Hi,

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

Regards,

David

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

rajni_batra — Thu, 06 Sep 2012 07:57:49 GMT

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

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

Anonymous — Thu, 06 Sep 2012 08:01:30 GMT

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

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

Anonymous — Thu, 06 Sep 2012 08:15:43 GMT

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

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

Anonymous — Thu, 06 Sep 2012 08:17:18 GMT

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

Can you explain your solution by words?

Thanks

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

rajni_batra — Thu, 06 Sep 2012 08:21:00 GMT

see the scrrenshot

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

Anonymous — Thu, 06 Sep 2012 08:52:35 GMT

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.

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

rajni_batra — Thu, 06 Sep 2012 09:02:57 GMT

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

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

Anonymous — Thu, 06 Sep 2012 09:55:29 GMT

Fantastic! That does exactly what I need. Thanks a lot Rajni!