topic Re: Bug or *feature by design*? Excel rand() & QV load in QlikView https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403713#M150187 <HTML><HEAD></HEAD><BODY><P>Ouch - completely forgot that I formatted the cell format.</P><P></P><P>But that means that QV is taking .value instead of .value2. Faster but it will ingore the format of a cell...not sure what to think about it, but seems a bit confusing for people who are working with a cell formating.</P></BODY></HTML> Thu, 11 Oct 2012 11:25:57 GMT 2012-10-11T11:25:57Z Bug or *feature by design*? Excel rand() & QV load https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403711#M150185 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>While I'm doing some tests here I noticed a strange thing with QV.</P><P></P><P>What I did is a sample xlsx for some random data - random ID from 0-4 in one column. Saved as an xlsx and load the file in QV. Worked with ApplyMap - but then it becomes strange:</P><P><IMG __jive_id="23311" class="jive-image-thumbnail jive-image" height="560" onclick="" alt="qv_xlsx_rand.png" src="https://community.qlik.com/legacyfs/online/23311_qv_xlsx_rand.png" width="823" /></P><P></P><P>First of all: ApplyMap is not working. Check the IDs box: No grouped values (for example, multiple 0!). So I saved the file under an CSV to get rid of the rand() function in the xlsx - everything's working as expected.</P><P></P><P>The main question is now: How does QV handles xlsx with rand() (or to be more general: with functions that could change a value). In my opinion it's ok that QV does a refresh on the document before it will load the data. But why didn't QV recognize same values and group them...?</P><P></P><P>Tested with QV11.</P></BODY></HTML> Thu, 11 Oct 2012 10:35:56 GMT https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403711#M150185 2012-10-11T10:35:56Z Re: Bug or *feature by design*? Excel rand() & QV load https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403712#M150186 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When numbers (values that are right aligned by default) are repeated (several zeroes in your example) sounds like they have decimals, although they are being represented as integers. Use instead</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13499536034108653" jivemacro_uid="_13499536034108653"><P>ApplyMap('LadenMap', Floor(Laden), 'not found') AS Bezeichnung,</P></PRE><P></P><P>So the Floor() function returns the integer part of the RAND() number generated by excel.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Thu, 11 Oct 2012 11:05:27 GMT https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403712#M150186 Miguel_Angel_Baeyens 2012-10-11T11:05:27Z Re: Bug or *feature by design*? Excel rand() & QV load https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403713#M150187 <HTML><HEAD></HEAD><BODY><P>Ouch - completely forgot that I formatted the cell format.</P><P></P><P>But that means that QV is taking .value instead of .value2. Faster but it will ingore the format of a cell...not sure what to think about it, but seems a bit confusing for people who are working with a cell formating.</P></BODY></HTML> Thu, 11 Oct 2012 11:25:57 GMT https://community.qlik.com/t5/QlikView/Bug-or-feature-by-design-Excel-rand-QV-load/m-p/403713#M150187 2012-10-11T11:25:57Z