Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rajendra1918
New Contributor II

select data at dimension level

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

4 Replies

Re: select data at dimension level

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?


talk is cheap, supply exceeds demand
jcampbell474
Contributor III

Re: select data at dimension level

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
Honored Contributor

Re: select data at dimension level

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
New Contributor II

Re: select data at dimension level

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

Community Browser