Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Have a look here: Data Types in QlikView
- Marcus
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..
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