Qlik Community

Qlik Deployment Framework

This group has been created to host, centralize and collect everything related to the Qlik Deployment Framework (QDF). QDF provides a set of best practices, libraries and utilities that facilitate the recommended setup and management of QlikView and Qlik Sense environments. Please note that an understanding of the Qlik platform is recommended before joining this group. <a href="https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases" rel="nofollow noopener noreferrer noopener noreferrer"> Download QDF 1.7.3 here!</a>

Highlighted
harson
New 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)




Tags (1)
3 Replies

Re: QlikView Filter

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

Life is so rich, and we need to respect to the life !!!
harson
New Contributor III

Re: QlikView Filter

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

Re: QlikView Filter

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

Life is so rich, and we need to respect to the life !!!