Select months below

danosoft — Tue, 05 Jul 2022 08:06:41 GMT

If I select a month I want the information to be shown in the graph as if I had selected all the months below. Example if I select 5 I want the graph to show me the values as if I had selected 1,2,3,4,5. I put the sample photos

This is field : mese_competenza

this is expression: Sum(CONSUMO_SMC) / Sum({1<ANNO=P(ANNO),DES_REFERENTE=P(DES_REFERENTE)>}BUD_VOLUMI)

how can I put the data in the expression as if I had selected all the months: 1,2,3,4,5 and not just the selected month?

Re: Select months below

Mark_Little — Tue, 12 Jul 2022 13:18:26 GMT

Hi,

Hard to advise fully as there are too many knowns. But the general appraoch i would use would be ad follows.

Create a variable to capture the selections - Var1

GetFieldSelections(Dimension)

Then add the following to the Set Analysis

Month={"<=$(Var1)"}

topic Re: Select months below in QlikView

Select months below

Re: Select months below