Filter QlikSense

[Talend45]

Hi all,

In my report I have a table with multiple columns among which I have a column "Send".

In this column "Send", if the invoices not being sent, I have the value "-", otherwise I have the date when the invoices was sent.

In this report I have other graphs (stacked bar ...).

I sometimes want to have only the invoices that were not sent and sometimes the invoices that were sent and sometimes all the invoices (sent and not sent).
For this, I filter on the column "Send" on the table by choosing "-" to have the invoices that were not sent and everything except "-" to have the invoices that were sent.
All the graphs are updated.

I want to add in my report theses values 
- All
- Sent
- Not sent

When I click to "Not sent" I have the same result when I click in the table on column "Send" by choosing the "-" 

....

Thanks you for your help !

[lanlizgu · Accepted solution]

You want to add three fields in the script?

All

Sent

Not Sent

You can create these three fields in their respective table of the script:

• add to all values "All" for the All field,
• for the Sent field use the "Sent" word of the Send field when send<>'-'
• For the Not Sent field use the ='-' word of the Send field

Maybe you have problems with '-' and you need to use isnull()

Thank you.

[Talend45]

Hi,

Thanks for your response.

I want when I click on "Sent", I have the same result when I select all my rows except "-" in my table. 

For example I have another graph
When the value is "Sent" the formula is : "avg(date 1 - date 2)
When the value is "Not send" the formula is : "avg(date 3 - date 4)

I must create two columns ? A column with "All" for all rows, A column with "Sent" or "Not send" ?

[lanlizgu]

Yes.