Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
different value of a concatenate field with qlik10.
if reload file.qvw with qlik9 or qlik10 the field keyCosto_New takes on different values.
Can you tell me if it happens to you?
I can not insert a file.qvw.
script:
set data_costo = date(date#(CSTDATE,'YYYYMMDD'));
Test:
LOAD * INLINE [
CSTDATE, SOC, ITEM, COST,
20100201, soc, pippo, 1,
20100301, soc, mario, 1,
];
Test_1:
LOAD
SOC &'-'& ITEM &'-'& COST as keyCosto,
ITEM,
COST,
SOC,
max($(data_costo)) as MAX_CSTDATE
resident Test
group by SOC,ITEM,COST;
drop table Test;
Test_2:
LOAD *,
keyCosto &'-'& MAX_CSTDATE as keyCosto_New
resident Test_1;
drop table Test_1;
Thanks
Hello Andrea,
I tested your little script and ... yes it happend to me. See the attached files for the different results using V9SR6 and V10SR1.
For my oppinion, the bug is in V9SR6 because the max() returns an integer. Or better: should returm an integer. If you convert it into a date, every thing works fine in both V9 and V10SR1. I verified this within your script.
P.S.: How long did you search for this, when your script worked always fine in V9? 😉
Regards, Roland
. . . and the addon to my previous post:
RR
Thanks Roland,
The problem occurred because the same file.qvw opens with Qlik 9 and qlik10.