Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem Show wrong Data

Hi Gurus, I´, really new in QW


 


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,


 


 


 


 


Sales Expression


<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">,0))


Budget Expression


<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">={<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">) - </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">={<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">), </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">))


 


Sales Expression


<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">,0))


 


Budget Expression


<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">={<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">) - </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">={<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="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 mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">), </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: blue; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: maroon; FONT-SIZE: 9pt" lang=EN-US mcestyle="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 mcestyle="font-family: 'Courier New'; color: black; font-size: 9pt;">)) </SPAN></P>

1 Solution

Accepted Solutions

Problem Show wrong Data

Hi,

   The values of expression are distributed as per the dimension.

   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.

Regards,

Kaushik Solanki

3 Replies

Problem Show wrong Data

Hi,

   The values of expression are distributed as per the dimension.

   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.

Regards,

Kaushik Solanki

Not applicable

Problem Show wrong Data

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?

Problem Show wrong Data

Hi,

  Join both the table with the month as key...

  So when you select month, it will give you respected values for both Sales and Budget.

Regards,

Kaushik Solanki

Community Browser