topic Need Help in QlikView

Need Help

paulwalker — Wed, 15 Oct 2014 07:07:02 GMT

Hi Community,

Table1:

Load * inline [

ID, Type

100, Regular

101, Special

102, SS-C

103, SS-ABC

104, SS-Max

105, SS-C2];

I want to return only

Type= Regular, Special and SS-C*

SS-C* Means starting with SS-C

OutPut Table:

ID, Type

100, Regular

101, Special

102, SS-C

105, SS-C2

Hope you understand...

Re: Need Help

alexandros17 — Wed, 15 Oct 2014 07:14:26 GMT

before ; write:

where Type ='Regular' or Left(Type ,2)='SS'

let me know

Re: Need Help

paulwalker — Wed, 15 Oct 2014 07:54:14 GMT

this is ok but i want

SS-C and SS-C2 i want to merge into one

SS-C

SS-C2 into one like SS

Like This

Type ='Regular' or Type='Special' or Wildmatch(Type, 'SS-C*'), 'SS')

but it's not working in where condition..

Did i mistake here???

Re: Need Help

PrashantSangle — Wed, 15 Oct 2014 08:03:09 GMT

Hi,

In script

load * from TableName where Wildmatch(Type,'Regular','Special','SS-C*');

In front end

USe Calculated Dimension,

if(wildmatch(Type,'SS-C*'),'SS',Type)

Regards

Re: Need Help

jagan — Wed, 15 Oct 2014 08:06:18 GMT

Table1:

Load

ID,

Type,

If(WildMatch(Type, 'SS-C*'), 'SS', Type) AS NewType

FROM DataSource

WHERE WildMatch(Type, 'Special', 'Regular', 'SS-C');

Hope this helps you.

Regards,

Jagan.

Re: Need Help

Wed, 15 Oct 2014 08:07:19 GMT

Hi,

Try This

Type ='Regular' or

Replace(Wildmatch(Type, 'SS-C*'), 'SS')

Re: Need Help

sunilkumarqv — Wed, 15 Oct 2014 08:11:08 GMT

Please find the attached

use of pick and wildmatch we can achieve that.