Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;"> <> 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;">({$ <</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;">}>} </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;">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;">}>} </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;"> <> 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;">({$ <</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;">}>} </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;">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;">}>} </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>
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
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
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?
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