topic Problem Show wrong Data in QlikView

topic Problem Show wrong Data in QlikView https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253960#M1192886 <HTML><HEAD></HEAD><BODY><P>Thanks Kausghik, I´ll fit it, on other  hand I have a Field PERIODO (Month) in my Oracle DB for Sales and have a Field Mes (Month) for Budget in my Excel File, I want to select any  of this value and Show  it for Both Expression Sales and Budget. Do you can sugest me what I need to do this Please?</P></BODY></HTML> Mon, 04 Jul 2011 17:40:55 GMT 2011-07-04T17:40:55Z Problem Show wrong Data https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253958#M1192884 <HTML><HEAD></HEAD><BODY><P></P><P>Hi Gurus, I´, really new in QW</P><P></P><P><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P>I have a problem when I want to show Budget & Sales data compare it, I´m using the same SET Expression for both Chart but show me a diferent result. I´m attaching the Example to show my problem. I apreciate if any body could help me with this issue,</P><P></P><P><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P><STRONG>Sales Expression</STRONG></P><P></P><P><BR /></P><P></P><P><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">Sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">If</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">T$DQUA$O</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;"> &lt;&gt; 0, </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">T$DQUA$O</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">,0)) <BR /><BR /><BR /></P><P></P><P><STRONG>Budget Expression</STRONG></P><P></P><P><BR /></P><P></P><P><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">if</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">rowno</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">()=0, </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">({$ &lt;</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Mes</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">={<STRONG><EM></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: gray; font-size: 9pt;">$(=max(Mes))</SPAN></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">}&gt;} </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Cantidad</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">) - </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">({$ &lt;</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Mes</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">={<STRONG><EM></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: gray; font-size: 9pt;">$(=max(Mes)-1)</SPAN></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">}&gt;} </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Cantidad</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">), </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Cantidad</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">)) <BR /><BR /><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P><STRONG>Sales Expression</STRONG></P><P></P><P><BR /></P><P></P><P><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">Sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">If</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">T$DQUA$O</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;"> &lt;&gt; 0, </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">T$DQUA$O</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">,0)) <BR /><BR /><BR /></P><P></P><P> </P><P></P><P><BR /></P><P></P><P><STRONG>Budget Expression</STRONG></P><P></P><P><BR /></P><P></P><P><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">if</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">rowno</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">()=0, </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">({$ &lt;</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Mes</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">={<STRONG><EM></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: gray; font-size: 9pt;">$(=max(Mes))</SPAN></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">}&gt;} </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Cantidad</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">) - </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">({$ &lt;</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Mes</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">={<STRONG><EM></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: gray; font-size: 9pt;">$(=max(Mes)-1)</SPAN></EM></STRONG><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">}&gt;} </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Cantidad</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">), </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Cantidad</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 9pt" lang=EN-US <U>mce</U>style="font-family: 'Courier New'; color: black; font-size: 9pt;">)) </SPAN></P></P></BODY></HTML> Mon, 04 Jul 2011 15:03:02 GMT https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253958#M1192884 2011-07-04T15:03:02Z Problem Show wrong Data https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253959#M1192885 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>   The values of expression are distributed as per the dimension.</P><P></P><P>   So here in your case you have used different dimensions for each chart and thats the reason you can see the different values. If you add them you will get the same value.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 04 Jul 2011 17:29:49 GMT https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253959#M1192885 kaushiknsolanki 2011-07-04T17:29:49Z Problem Show wrong Data https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253960#M1192886 <HTML><HEAD></HEAD><BODY><P>Thanks Kausghik, I´ll fit it, on other  hand I have a Field PERIODO (Month) in my Oracle DB for Sales and have a Field Mes (Month) for Budget in my Excel File, I want to select any  of this value and Show  it for Both Expression Sales and Budget. Do you can sugest me what I need to do this Please?</P></BODY></HTML> Mon, 04 Jul 2011 17:40:55 GMT https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253960#M1192886 2011-07-04T17:40:55Z Problem Show wrong Data https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253961#M1192887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>  Join both the table with the month as key...</P><P></P><P>  So when you select month, it will give you respected values for both Sales and Budget.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 05 Jul 2011 06:13:45 GMT https://community.qlik.com/t5/QlikView/Problem-Show-wrong-Data/m-p/253961#M1192887 kaushiknsolanki 2011-07-05T06:13:45Z