Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I have problems with compare smallint fields

Hello

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

 

ProNomCod =2

ProNomCod is Smallint and i have problem.

Helpme

please

7 Replies
anbu1984
Master III
Master III

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

Joseph_Musekura
Support
Support

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

Not applicable
Author

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

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,

Not applicable
Author

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

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

Joseph_Musekura
Support
Support

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,