topic Re: Help on syntax in QlikView

Help on syntax

Fri, 23 May 2014 07:19:58 GMT

Hello folks

I need help With syntax. I will combine two Expressions, but i dont't get it right. Please help

String 1: Sum({$<Month, Year>}Ordtime}

String 2: Sum({<Arbeidsbeskrivelse -={'ikke definert(std)','Favær(std)'}>}Ordtime)

Result (not working): Sum({$<Month, Year, Arbeidsbeskrivelse -={'Ikke Definert(std)','Fravær(std)'>}Ordtime)

Gunnar Schie

Anonymous — Fri, 23 May 2014 07:27:24 GMT

Try this and let me know

Sum({$<Arbeidsbeskrivelse -={'Ikke Definert(std)','Fravær(std)'}>}Ordtime)

anbu1984 — Fri, 23 May 2014 07:29:35 GMT

Can you post sample app

tresB — Fri, 23 May 2014 07:30:43 GMT

Sum({$<Month=, Year=, Arbeidsbeskrivelse -={'Ikke Definert(std)','Fravær(std)'}>} Ordtime)

Fri, 23 May 2014 07:37:38 GMT

Hello, thanks for help. Sorry, it did nor work well.

Fri, 23 May 2014 07:38:40 GMT

Hello treseco

This working Perfect, thank's for Your help!!

Anonymous — Fri, 23 May 2014 07:39:16 GMT

I hope tresesco's answer worked