Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have problems with compare smallint fields, makes the comparison.
ProNomCod =2
ProNomCod is Smallint and i have problem.
Helpme
please
Where did you try comparison? Can you explain what didnt work for you?
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
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..
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,
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
QlikView does not implement a "smallfield" type, could you elaborate more your issue?
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,