See all values in a consolidated balance

[francisvandergr]

I have made a qvw with data from 2 databases with the same tables. We want to have one report with data from 2 databases. I wanna see also numbers where no booking is found in the table 'grootboekmutaties' for example grootboeknummer : 4010,4040 and 4050.

When i select nothin i see everything, but i will also see all numbers of grootboek when i select a database or a year.

Anybody who can help me with this. Is is important for accountants.

[pover · Accepted solution]

So that the rows never change, in your first expression put

only({1} OMSCHR)

With one expression that ignores the filters, QlikView shouldn't hide any dimension.

Regards.

[francisvandergr]

thnx you helped me!!