topic Re: set analysis defining a number field in QlikView

set analysis defining a number field

Anonymous — Thu, 19 Jun 2014 09:44:58 GMT

Hi Folks,

I am working on an Expression to show me the sum of LIEFERSCHEIN if the value in a certain Field called PREISVK ist less (or more) than € 31,00.

Result should Show like this (see coloumn Test):

My Expression for the coloumn Test is:

Count({$<PreisVK=>}Lieferschein) and it Shows me 22 which is correct.

As soon as I set the following

Count({$<PreisVK=35>}Lieferschein it Shows me 0, which is wrong and should be 1 (see Listing)

Is there anybody who can help and explain! I am through several tests with brackes, quotes, double quotes...
but without success so far.

Thanks a lot in advance!

Wolfgang

Re: set analysis defining a number field

mdmukramali — Thu, 19 Jun 2014 09:52:51 GMT

Dear ,

can you try below expression.

Count({$<PreisVK={35}>}Lieferschein)

Thanks,

Mukram

Re: set analysis defining a number field

tresB — Thu, 19 Jun 2014 09:56:20 GMT

Numeric values don't need to be enclosed by quotes, but have to be within curly braces, like:

Count({$<PreisVK={35}>}Lieferschein )

Re: set analysis defining a number field

Anonymous — Thu, 19 Jun 2014 10:11:45 GMT

Thank you so much, however, .... it does not work,
resulting in 0 but should be 1.

With or without brackets, quotes, double quotes...

Wolfgang

Re: set analysis defining a number field

Anonymous — Thu, 19 Jun 2014 10:12:37 GMT

Thanks Mukram,

but it does not work

Wolfgang

Re: set analysis defining a number field

mdmukramali — Thu, 19 Jun 2014 10:14:10 GMT

Dear,

can you attach the sample file so that we can help you.

Thanks,

Mukram.

Re: set analysis defining a number field

tresB — Thu, 19 Jun 2014 10:15:00 GMT

The problem is not with set or expression anymore. Explore your app for other issues, or share a sample app.

Re: set analysis defining a number field

Anonymous — Thu, 19 Jun 2014 10:57:24 GMT

Heureka,
indeed the field PreisVK is already a Currency field, more than a number.

So I checked this and tried

{=31,00 €"}

which works and which I also can calculate with.

Thanks to both of you for your help and Input,

always a pleasure!

Wolfgang

Re: set analysis defining a number field

swuehl — Thu, 19 Jun 2014 11:10:51 GMT

If you want to perform a search using a condition larger than or smaller than, this should work

=Count({$<PreisVK= {">31"} >} Lieferschein)

=Count({$<PreisVK= {"<=31"} >} Lieferschein)

Re: set analysis defining a number field

Anonymous — Thu, 19 Jun 2014 12:15:16 GMT

Thank you so much,

as already described above: this was a Problem of the Format,
I expected the field to be a number field, however, it is a currency field and the
Format should be {"<31,00 €"}

It works, great,

thanks your input

Wolfgang