Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my script I have the following load:
%ORGKEY,
%PERIODEKEY,
%KONTOKEY,
BeløpTransSEK
FROM $(TransformFolderRegnskap)\FAKTA.QVD (qvd) where (Right(%KONTOKEY,4)=6340 OR Right(%KONTOKEY,4)=7190);
This gives me all the transactions/amounts (BelopTransSEK) for two given accounts, 6340 and 7190.
If I create a chart with SUM(BelopTransSEK) this will give me the total amount for both accounts. I just want to have the total for the 7190 account in one chart and the total for 6340 in a different chart.
How can I filter the chart so that it only gives me the total for one account at the time?
Hi,
There are so many ways to get your result.
Add %KONTOKEY field in your dimension. it will slice the value based on your dimension.
else
use set analysis
Hi
in your case, I use Set analysis. try to create a new chart with such expression: sum({<%KONTOKEY = {"*6340"}>} BelopTransSEK) and another chart with another filter.
Hi,
Create one more field in ur script as Right(%KONTOKEY,4) as Flag
Use this flag in ur set analysis like
sum({<Flag={6340}>}BelopTransSEK) in one chart
sum({<Flag={7190}>}BelopTransSEK) in another chart
Hope it helps you.
Regards,
Khadeer
Hi,
Kumar answer is correct. But, if you use text objects for 2 different account sums then use the below set expression.
sum({<%KONTOKEY = {'7190'}>} BelopTransSEK)
sum({<%KONTOKEY = {'6340'}>} BelopTransSEK)