topic Re: Total without selection in QlikView

Total without selection

clovati — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have this:

LOAD * INLINE [

Continent, Country, Town, Revenue

EUROPE, ITALY, Milan, 100

EUROPE, ITALY, Turin, 200

EUROPE, ITALY, Rome, 300

EUROPE, ITALY, Naples, 400

EUROPE, FRANCE, Paris, 10

EUROPE, FRANCE, Bordeaux, 20

EUROPE, FRANCE, Mareille, 30

];

If I create a list box for Town, I want anyway the whole TOTAL for COUNTRY and CONTINENT... how can I do?

In other words:

without selection I obtain:

And If I select just Paris, Mlan, Naples I would obtain this, with alla totale values laike having not done any selection:

Thank in advance!

Anil_Babu_Samineni — Mon, 13 Nov 2017 13:57:42 GMT

i am not facing any issue

sunny_talwar — Mon, 13 Nov 2017 14:01:00 GMT

Not sure, but may be you need this (I used Anil's qvw to test this.... pfa the modified version)

=If(Dimensionality() = 3, Sum(Revenue), Sum({<Town>}Revenue))