topic Re: Autonumberhash in QlikView

Autonumberhash

rdsuperlike — Wed, 21 Jan 2015 22:03:05 GMT

Wats wrong with the below syntax, I want to use If and Name l beginning from A90 or D90 or P90. But below script doesnt work.

AutoNumberHash128(IF([Name] like 'A90*', IF([Name] like 'P90*',If([Name] like 'D90*',([Part] &'-' & FLOOR(Date([Schedule ]))))))) AS DT_KEY

Any inputs?

swuehl — Wed, 21 Jan 2015 22:10:47 GMT

I think this will like ... beginning from A90 AND D90 AND P90 which obviously doesn't work.

Try Wildmatch() instead:

AutonumberHash128( If( Wildmatch([Name],'P90*','D90*','A90*'), [Part] &'-' & FLOOR(Date([Schedule ])) ) AS ...

MarcoWedel — Wed, 21 Jan 2015 22:19:47 GMT

If(Wildmatch(Name, 'A90*','P90*','D90*'),AutonumberHash128(Part, Floor([Schedule ]))

could work, if you only want to generate key values for distinct combinations of Part and Schedule days if Name starts with A90, D90 or P90.

hope this helps

regards

Marco