topic Re: Implicit and Explicit Conversion in QV in QlikView

Implicit and Explicit Conversion in QV

Anonymous — Thu, 17 Dec 2015 07:37:05 GMT

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

Re: Implicit and Explicit Conversion in QV

marcus_sommer — Thu, 17 Dec 2015 07:41:12 GMT

Have a look here: Data Types in QlikView

- Marcus

Re: Implicit and Explicit Conversion in QV

Anonymous — Thu, 17 Dec 2015 07:55:43 GMT

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

Re: Implicit and Explicit Conversion in QV

marcus_sommer — Thu, 17 Dec 2015 08:05:46 GMT

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