Discussion Board for collaboration on QlikView Scripting.
Hi Friends, I have a column name with
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.
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?
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)
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.
I want trying to get the data from one column (data_list) in that only a word which start from "apj" only.
@ jason and bhaskar Thanks, i have used if condition. it is working fine.