select data at dimension level

[rajendra1918]

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

[Gysbert_Wassenaar]

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?

[jcampbell474]

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)

[balabhaskarqlik]

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.

[rajendra1918]

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