Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Talend45
Contributor III
Contributor III

Filter

Hello,

I don’t know how to do

For exemple, I have a database with a field « date creation».

I want to get all the date where the date_creation is greater than a value.

I saw it’s possible to do this in the load script with the « where condition » to have only the data wanted.

But in my report, I need all the data so I must load all the data.

I see it’s possible like this video but I have 1000 different date so I can’t select manually my data ...

https://youtu.be/0TQSdhGYxHQ

Do you have an idea ?

Thanks you.

1 Solution

Accepted Solutions
Taoufiq_Zarra
Master II
Master II

oui exactement avec if ça marchera

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

4 Replies
Taoufiq_Zarra
Master II
Master II

Hi,

can you provide more detail about the need, because there are several possibilities:

if you want to simply create a list you can do :

=if(Date_creation>LA_Valeur,Date_creation)

otherwise you can use Set Analysis in case expression for example : if you want to calculate sales greater than a date XX

= sum({<Date_Creation= {">=$(=$(variable))"} Sales)

so there are several possibilities depending on what you want to do

 

Bonne fin de soirée

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Talend45
Contributor III
Contributor III

Bonsoir Taoufiq,

Dans mon rapport je veux juste afficher les dates supérieure à une date voulue.

Ca marche en utilisant un if ? Si par exemple j’ai un champ « libelle » avec différentes valeurs « Envoye » « Cree » ... et que je veux afficher uniquement la valeur « Envoye  » sans passer par une clause where

 

Taoufiq_Zarra
Master II
Master II

oui exactement avec if ça marchera

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Talend45
Contributor III
Contributor III

Merci !