topic Re: SELeCTION LIST VALUE in QlikView

SELeCTION LIST VALUE

souadouert — Fri, 17 Mar 2017 15:20:22 GMT

HI,

CAN I FILTER THE VALUE OF A SELECTION LIST?

Re: SELeCTION LIST VALUE

sunny_talwar — Fri, 17 Mar 2017 15:22:16 GMT

Selection list? What do you mean Souad?

Re: SELeCTION LIST VALUE

souadouert — Fri, 17 Mar 2017 15:26:52 GMT

I want to display only conditional values

Re: SELeCTION LIST VALUE

souadouert — Fri, 17 Mar 2017 15:28:13 GMT

Re: SELeCTION LIST VALUE

sunny_talwar — Fri, 17 Mar 2017 15:29:43 GMT

What type of chart is this? Straight table or table box?

Re: SELeCTION LIST VALUE

souadouert — Fri, 17 Mar 2017 15:33:34 GMT

I have a table link ,in this table there is a column date and column product, so I want to show only the date with product = "BAD"

Re: SELeCTION LIST VALUE

Anil_Babu_Samineni — Fri, 17 Mar 2017 15:40:53 GMT

May be this

Fact:

Load * from LinkTable;

Left Join(Fact)

Load Date, Product Resident Fact where Product = 'BAD';

Re: SELeCTION LIST VALUE

vishsaggi — Fri, 17 Mar 2017 15:42:58 GMT

You want to show this in your lisbox Date_Situation.Situation_Product?

You can try in your listbox expression:

= IF(Product = 'BAD', Date_Situation.Situation_Product)

Re: SELeCTION LIST VALUE

sunny_talwar — Fri, 17 Mar 2017 15:44:46 GMT

Show this in table box or straight table?

Re: SELeCTION LIST VALUE

souadouert — Fri, 17 Mar 2017 19:46:51 GMT

didnt work

Re: SELeCTION LIST VALUE

sunny_talwar — Fri, 17 Mar 2017 19:51:08 GMT

Try this on the General tab instead of Expression tab

Re: SELeCTION LIST VALUE

sunny_talwar — Fri, 17 Mar 2017 19:52:19 GMT

Look at the image

Re: SELeCTION LIST VALUE

vishsaggi — Fri, 17 Mar 2017 19:53:45 GMT

Thanks Sunny, I meant to use there. Yes, Souad try that in expression tab as in the snapshot shown in sunny's reply.

Re: SELeCTION LIST VALUE

souadouert — Fri, 17 Mar 2017 20:08:22 GMT

thx sunny

Re: SELeCTION LIST VALUE

MarcoWedel — Fri, 17 Mar 2017 23:31:51 GMT

another listbox expression could be:

=Aggr(Only({1<Product={'BAD'}>} Date_Situation.Situation_Product),Date_Situation.Situation_Product)

hope this helps

regards

Marco