I have problems with compare smallint fields

[#1]

Hello

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

ProNomCod =2

ProNomCod is Smallint and i have problem.

Helpme

please

[anbu1984]

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

[Joseph_Musekura]

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

[#4]

  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..

[Joseph_Musekura]

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,

[#6]

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

[Clever_Anjos]

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

[Joseph_Musekura]

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,