Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table values filtering

Hi.

I've got an issue with one table where I want to filter values that are not corresponding to my query. Or more exactly, the current query I make let appear all the values.

Here is the screenshot of the table.

Capture.JPG

In this table, the first 2 columns are dimensions (customer code and date of delivery)

the 3rd one is based on this expression :

count(DISTINCT {$<[Entete Souche]={'Facturation'}, [Entete Type]={6},[Entete Provenance]={'Avoir'},[Entete Type Avoir]={"GLOBAL"}>} CodeDocument)

and works perfectly

and the 4th is currently :

=count({1<[Entete Souche]={'Facturation'}, [Entete Type]={6},[Entete Provenance]={'Facture'}>} DISTINCT CodeDocument)

This expression is giving me all the deliveries within the database but I want only to get those correspondig to the customers that have an "Avoirs" (column 3 > 0). I've tried different solutions but none work for now.

Any idea ?

10 Replies
Not applicable
Author

Hehe. That's so simple. You've done it Gysbert. THank you very much. (I fee a bit stupid not to have think of that ^^)