topic Re: How to exclude % by using set analysis in QlikView

How to exclude % by using set analysis

vinod2086 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have a requirement as below. when i select single id it should take Target Site and when i select Multiple id's it will take Target Aggr.

i have used mentioned exp

=If(Count([Id])=1,Only(Site_Target),Only(Aggr_Target))

here everything is fine but target Aggr i need to exclude '= ' and '%' (user dont want to see = and % like insted of =0% i need to display 0, 100,95 so on)

how to write condition.

Target Site	Target Aggr
0	=0%
0	=100%
0	=100%
0	=100%
1	>=95%
1	>=95%

expected output

if it is =0% o/p is 0

=100% o/p is 1

>=95% o/p is >=95

Re: How to exclude % by using set analysis

prma7799 — Thu, 05 Oct 2017 10:52:40 GMT

Try like this

=PurgeChar('Aggr_Target','>=%')

Re: How to exclude % by using set analysis

marcus_sommer — Thu, 05 Oct 2017 10:53:22 GMT

Maybe with: keepchar(Only(Aggr_Target), '0123456789')

- Marcus

Re: How to exclude % by using set analysis

its_anandrjs — Thu, 05 Oct 2017 11:03:19 GMT

You can use mapping table for this and map with decimal values with its corresponding value and if not found in applymap then use the Null() to fill null value there.

MapTab1:

Mapping Load * Inline

[

Target Aggr, Decimal Value

0%,0

=100%,1

>=95%,0.95

];

Fact:

Load

Applyname('MapTab1',[Target Aggr],Null())

Re: How to exclude % by using set analysis

qlik4asif — Thu, 05 Oct 2017 11:16:18 GMT

HI Vinod,

You can give as PurgeChar('Aggr_Target','=%')

It will omit = and % and give only the values.

If the issue is solved pls mark it as solved

Thanks

Asif

Re: How to exclude % by using set analysis

its_anandrjs — Thu, 05 Oct 2017 11:55:01 GMT

Another approach is KeepChar at script and UI level

Load *,

KeepChar([Target Aggr],'0123456789%') as [Decimal Value],

From .....

Ex:-

Load *,

KeepChar([Target Aggr],'0123456789%') as [Decimal Value] Inline

[

Target Aggr

=100%

>=95%

];