topic Re: cannot use '>' in set analysis in QlikView

cannot use '>' in set analysis

Tue, 19 Aug 2014 15:04:26 GMT

Hi,

I'm having a problem using '>' in a set analysis.

The expression works fine without '>', but after adding '>', it returns 0.

=sum({1<period={">=1"}>}sales)

What could be the reason?

Thanks,

dodo

Re: cannot use '>' in set analysis

marcus_sommer — Tue, 19 Aug 2014 15:10:21 GMT

Are you sure that you have a numeric period and there are values >= 1? Then generally these syntax worked.

- Marcus

Re: cannot use '>' in set analysis

Tue, 19 Aug 2014 15:18:41 GMT

Yes, 12 periods, all have numbers. And, the expression works if I make it equals to any period.

Re: cannot use '>' in set analysis

marcus_sommer — Tue, 19 Aug 2014 15:23:57 GMT

Please post a small example - this worked for me:

= sum({<Monat={">=11"}>} Values)

- Marcus

Re: cannot use '>' in set analysis

Tue, 19 Aug 2014 15:27:44 GMT

In this link you can find a set analysis wizard it will help you to generate the expression in the way that you want:

Set Analysis Wizard for QlikView | qlikblog.at

Re: cannot use '>' in set analysis

Anonymous — Tue, 19 Aug 2014 15:36:20 GMT

Hi,

Please use below expression:

=sum({1<period={"<13"}>}sales)

Re: cannot use '>' in set analysis

lft — Tue, 19 Aug 2014 15:41:27 GMT

In some occasions, QlikView can consider that numerical values are text. This can happen for instance when the source file is excel, and that the cell type in excel is text, and not numerical.

in this case

the = statement in set analysis works, because QlikView makes a string to string comparison : "1" = "1" returns true

the >= statement does not because we don't have an inequality comparator on strings : "1" >= "1" returns false

have you tried forcing the column type in the script using for instance "Num(period) as period"

you could also force a numerical type in the document properties ("number" tab)

Loic

Re: cannot use '>' in set analysis

aveeeeeee7en — Tue, 19 Aug 2014 15:47:40 GMT

See this:

restrict data in a table

Regards

Aviral Nag

Re: cannot use '>' in set analysis

jaimeaguilar — Tue, 19 Aug 2014 15:53:27 GMT

Hi,

in order to check if your field is reading values as number you can either check it in the table viewer (ctrl + T) and put the mouse over the field in the data model to see the type of data of that field. Another option is creating a listbox/tablebox with this field. By default qlikview aligns numbers to right and text to left,

regards

Re: cannot use '>' in set analysis

Tue, 19 Aug 2014 17:37:12 GMT

Thanks for all the replies!

Loic gave the best explanation.