topic Re: select data at dimension level in QlikView

select data at dimension level

rajendra1918 — Mon, 10 Jul 2017 10:59:15 GMT

Hi Friends, I have a column name with

data_list

apj apple,

apj samsung,

apj nokia,

apj micromax,

apj celkon,

apj htc

apj sony

apj redmi

apj alcatel

i want to select only apj apple,apj htc,apj sony data from data_list column

using at dimension level is there any way for those particular data selection??

if yes please share your ideas in qlik sense.

Regards,

Rajendra

Re: select data at dimension level

Gysbert_Wassenaar — Mon, 10 Jul 2017 17:43:32 GMT

I don't understand your question. I'm assuming you don't simply want to select the values in the data_list field by hand using for example a filter pane. Can you explain what you're trying to do?

Re: select data at dimension level

jcampbell474 — Mon, 10 Jul 2017 17:49:36 GMT

I'm not sure if this is what you're asking for, but you can add a calculated dimension to filter the desired dimensions.

In the object, use:

=If(data_list = 'apj apple' or data_list='apj htc' or data_list='apj sony',data_list)

Re: select data at dimension level

BalaBhaskar_Qlik — Mon, 10 Jul 2017 18:14:46 GMT

Load the 'Data_list' column data, execute it.

select list box - Expression - mention this: =If(data_list = 'apj apple' or data_list='apj htc' or data_list='apj sony',data_list).

Now list box generated only with desired results.

Re: select data at dimension level

rajendra1918 — Tue, 11 Jul 2017 09:31:57 GMT

Hi,

I want trying to get the data from one column (data_list) in that only a word which start from "apj" only.

data_list

apj apple

apj samsung

apj nokia

apj micromax

apj celkon

apj htc

apj sony

apj redmi

apj alcatel

emea apple

emea samsung

emea micromax

emea htc

@ jason and bhaskar Thanks, i have used if condition. it is working fine.

Regards,

Rajendra