topic Re: how to filter values from field in QlikView

how to filter values from field

sakamsureshbabu — Thu, 24 Dec 2015 07:23:06 GMT

Hi All,

I have data like below

model:

Model	cost
Nokia-att	45
lumia-at&t	73
Samsung	34
lg-airtel	32
Sony	65
micro max	32

where i want to create one more field that should have only '-'

Model	cost
Nokia-att	45
lumia-at&t	73
lg-airtel	32

i need like this how can i create.

Thanks ...........

Re: how to filter values from field

MK_QSL — Thu, 24 Dec 2015 07:45:06 GMT

LOAD Model,

cost,

If(SubStringCount(Model,'-')>0,1,0) as Flag

FROM

[https://community.qlik.com/thread/197647]

(html, codepage is 1252, embedded labels, table is @1);

Now create a Straight Table

Dimension

Model

Expression

SUM({<Flag = {1}>}cost)

Re: how to filter values from field

Peter_Cammaert — Thu, 24 Dec 2015 12:55:29 GMT

Or without changing your script at all:

=sum({<Model = {'*-*'}>} Cost)

The set analysis reduces the list of Dimension values in the current object to those that contain a hyphen.

Best,

Peter

Re: how to filter values from field

Anonymous — Thu, 24 Dec 2015 13:07:51 GMT

may be like this at script like:

LOAD Model,

cost,

If(Model like '*-*', Model) as NewModel

FROM

[https://community.qlik.com/thread/197647]

(html, codepage is 1252, embedded labels, table is @1);

Now take NewModel as a dimension, hope this will help!!

Re: how to filter values from field

veidlburkhard — Thu, 24 Dec 2015 13:36:49 GMT

Hi Suresh,

below see how to adjust your script to get the new field you want to use and what to achieve with that in UI:

Hope this helps

Burkhard

Re: how to filter values from field

sakamsureshbabu — Wed, 06 Jan 2016 05:34:18 GMT

Hi Manish,

Tanks.

Re: how to filter values from field

sakamsureshbabu — Wed, 06 Jan 2016 05:34:46 GMT

Hi Peter,

Thanks.

Re: how to filter values from field

sakamsureshbabu — Wed, 06 Jan 2016 05:35:18 GMT

Hi Balraj,

Thanks.

Re: how to filter values from field

sakamsureshbabu — Wed, 06 Jan 2016 05:36:51 GMT

Hi Burkhard,

Thanks for your explanation,i got it some another way.

Both are working.