topic SET analysis syntax problem in QlikView

SET analysis syntax problem

Tue, 09 Dec 2014 08:56:31 GMT

I´m trying to use this

round((count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR))/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR))*100,0.1 & '%'

but there is a problem somewhere at the end???????

Re: SET analysis syntax problem

morganaaron — Tue, 09 Dec 2014 09:01:53 GMT

Is 0.1 your step for rounding? If so, you need to remove the second bracket after JOURNALNR and put a bracket after the 0.1.

Re: SET analysis syntax problem

Tue, 09 Dec 2014 22:57:55 GMT

why you need parenthesis around the first count, remove it. That makes it cleaner.

Re: SET analysis syntax problem

Anonymous — Wed, 10 Dec 2014 00:18:41 GMT

Here it is:

if you want to perform round for first part below is the one.

=round(count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR))/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR)*100,0.1 & '%'

if you want to perform round for whole then below:

=round(count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR)/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR))*100,0.1 & '%'

and I don't understand why you kept 0.1 you can remove it if not required

Hope this helps.

BR,

Chinna

Re: SET analysis syntax problem

jagan — Wed, 10 Dec 2014 03:05:48 GMT

Hi,

Check this expression below

=round((count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR)/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR)*100),0.1) & '%'

Regards,

Jagan.