Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harson
Contributor III
Contributor III

QlikView Filter

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))

test.JPG


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)




3 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
harson
Contributor III
Contributor III
Author

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

Anil_Babu_Samineni

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))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)