topic Re: Filter in chart in QlikView

Filter in chart

Tue, 20 Aug 2013 11:26:02 GMT

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?

Re: Filter in chart

kumarnatarajan — Tue, 20 Aug 2013 11:36:36 GMT

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

Re: Filter in chart

sparur — Tue, 20 Aug 2013 11:43:02 GMT

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.

Re: Filter in chart

khadeer — Tue, 20 Aug 2013 11:43:17 GMT

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

Re: Filter in chart

Tue, 20 Aug 2013 11:45:12 GMT

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)