topic Re: I have problems with compare smallint fields in QlikView

I have problems with compare smallint fields

Sat, 26 Apr 2014 00:37:14 GMT

Hello

I have problems with compare smallint fields, makes the comparison.

ProNomCod =2

ProNomCod is Smallint and i have problem.

Helpme

please

Re: I have problems with compare smallint fields

anbu1984 — Sat, 26 Apr 2014 07:08:31 GMT

Where did you try comparison? Can you explain what didnt work for you?

Re: I have problems with compare smallint fields

Joseph_Musekura — Sat, 26 Apr 2014 07:27:21 GMT

Hi,

We have different comparison functions in QlikView. Check this blog for example:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use

If you need more assistance, please add a sample of your *.qvw and explain what you want to achieve with the comparison.

/joseph

Re: I have problems with compare smallint fields

Sat, 26 Apr 2014 11:59:27 GMT

Hello

This field HisPagAnoPro is smallint,

If(ProNomCod=2 and HisPagAnoPro = Vano and HisPagFlgRev <>'R',EmpCod,'-'),

I have problems with compare smallint fields, no comparison is made.

Helpme

Please..

Re: I have problems with compare smallint fields

Joseph_Musekura — Sat, 26 Apr 2014 13:29:40 GMT

Hi again,

If in your statement, “Vano” is a variable, you need to use ”$ -dollar expansion” instead.

ex: HisPagAnoPro = $(Vano) or HisPagAnoPro = '$(Vano)'

Use “HELP” or check how to use dollar expansion in Qlikview reference manual. You can find the reference manual in C:\ProgramData\QlikTech\QlikView Documentation\Reference Manual

Regards,

Re: I have problems with compare smallint fields

Sat, 26 Apr 2014 14:55:32 GMT

Hello:

I think the problem is the field,

to change the field from smallint to int or char does not issue.

then if the comparison runs.

help me

Re: I have problems with compare smallint fields

Clever_Anjos — Sat, 26 Apr 2014 17:29:37 GMT

QlikView does not implement a "smallfield" type, could you elaborate more your issue?

Re: I have problems with compare smallint fields

Joseph_Musekura — Sun, 27 Apr 2014 07:20:48 GMT

Hi,

You need to know how qlikview deal with data type and then during the ETL phase format your data accordingly .

Refer to QlikView manual that you can find in (if you kept the default installation path):

C:\ProgramData\QlikTech\QlikView Documentation\Reference Manual

The reference manual indicate that " All of the data loaded into QlikView is available in two representations,

as a string and as a number. The string representation is always available and is what is shown in the list box.....".

It will be easy if you add a sample of your *.qvw (make it very sample) as I said previously.

Regards,