topic Re: QlikView Filter in Archived Groups

QlikView Filter

harson — Tue, 22 Jul 2025 17:59:49 GMT

Hello community,

I have a problem with QlikView.

I have a table, with

Dimension: =ValueList('A','B','C','D')

And 4 expressions :

Janv : if(ValueList('A','B','C','D')='A',Sum({<Month={'janv.'}>}Nb_files))

Fev : if(ValueList('A','B','C','D')='A',Sum({<Month={'févr.'}>}Nb_files))

Mars : if(ValueList('A','B','C','D')='A',Sum({<Month={'mars'}>}Nb_files))

Avr : if(ValueList('A','B','C','D')='A',Sum({<Month={'avr.'}>}Nb_files))

What I would like to do is display only in the table the data of the months less than or equal to the selected month.

For example : if I select the month of Mars, in the table the data of Janv, Fev, Mars AND empty on Avr.

Attached my qlikview file.

Thank you in advance for your help.

(I'm sorry for my English, I don’t speak English very well)

Anil_Babu_Samineni — Thu, 17 Aug 2017 08:47:34 GMT

Then, Why do you need B,C,D in your list?

harson — Thu, 17 Aug 2017 08:52:17 GMT

I have several axpression, in B : =Avg(Nb_files) , in C Min(Nb_files), in D Max(Nb_files)

Anil_Babu_Samineni — Thu, 17 Aug 2017 09:02:25 GMT

May be explain little more your business, We can figure it out more easy

Janv : if(ValueList('A','B','C','D')='A',Sum({<Month={'janv.'}>}Nb_files))

Fev : if(ValueList('A','B','C','D')='A',Sum({<Month={'févr.'}>}Nb_files))

Mars : if(ValueList('A','B','C','D')='A',Sum({<Month={'mars'}>}Nb_files))

Avr : if(ValueList('A','B','C','D')='A',Sum({<Month={'avr.'}>}Nb_files))

When you use Static it won't work rather try this?

if(ValueList('A','B','C','D')='A',Sum({<Month={'$('<=' & =Max(Month))'}>}Nb_files))