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

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

Implicit and Explicit Conversion in QV

Hello Experts,

This Implicit and Explicit conversion happens in programming languages like C,C++,Java,.NET etc..

Does this thing exist in Qlikview as well?

Please share your thoughts.

Regards,

Balraj Ahlawat

1 Solution

Accepted Solutions
marcus_sommer

Because qlikview runs for this only through the symbol-table the string-interpretation from the values which is only one one which is visible is missing and will be replaced per "?" but the correct values are there and would you calculate with it you will get the correct result.

Solution is to add a string-interpretation per format-function or per dual, see also: Re: Problem with FieldValue

- Marcus

View solution in original post

3 Replies
marcus_sommer

Have a look here: Data Types in QlikView

- Marcus

Anonymous
Not applicable
Author

Thanks Marcus for sharing this, and I understand Data Types in QV and their importance.

Today I was creating a master calender and I faces this scenario, I tried it into two way:

One way, Preceding Load:

load

Min(FieldValue('Date',RecNo())) as MinDate,

max(FieldValue('Date',RecNo())) as MaxDate

AutoGenerate FieldValueCount('Date');

Result of Preceding: getting  ?  as an output of both the date...but if I use format function for both then I am getting values for both the dates

2nd Way, Resident Load:

load

min(Date) as MinDate,

max(Date) as MaxDate

Resident Table;

Result Of Resident: getting value for both the dates without format function

Could you suggests me why this is happening? Why we required to use format function in case of preceding load?

see the attachment as well..

marcus_sommer

Because qlikview runs for this only through the symbol-table the string-interpretation from the values which is only one one which is visible is missing and will be replaced per "?" but the correct values are there and would you calculate with it you will get the correct result.

Solution is to add a string-interpretation per format-function or per dual, see also: Re: Problem with FieldValue

- Marcus