Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

"Selective" Report

All,

Is it possible to make a report in Q-Sense that uses only a few elements of a dimension?

For example of my 'general ledger'-dimension only the account 700000 and 700001 without using a filter on this dimension.

Thank you

W.

5 Replies
arulsettu
Honored Contributor III

Re: "Selective" Report

may be your 'general ledger' is like this

700000

700001

700002

700003

700004

700005


and you want to see only 700000 and 700001


try like this in your dimension


if(match('general ledger','700000','700001'),'general ledger')

Re: "Selective" Report

Yes, that's possible. As Arul points out above you can use a calculated dimension. You could also change create it as a new field in the script and use that as dimension. And if you use an chart that has measures you could change the measure expressions to filter the accounts. For example Sum(Amount) would become Sum({<Account={700000,700001}>}Amount).

Not applicable

Re: "Selective" Report

This formula gives me the account 700000 and 700001 but the other accounts are still in the report.

The report that I want to build:

Account 700000

blank

Account 700001 +700003

blank

Account  700005

Is this possible with a calculated dimension?

Thx

W.

arulsettu
Honored Contributor III

Re: "Selective" Report

can you post some sample qvw along with your expected output..

Not applicable

Re: "Selective" Report

perhaps use APPLYMAP Brief Explanation about Apply map

create an inline mapping load with the accounts you want to list, then use NULL() as the alternative in the APPLYMAP function

[AccountShow]:

MAPPING LOAD * INLINE [

Account, Display

700000, 700000

700001, 700001

];

LOAD

APPLYMAP('AccountShow',Account,NULL()) AS General_Ledger

...