Skip to main content

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Talend45
Contributor III
Contributor III

Filter QlikSense

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 !

1 Solution

Accepted Solutions
lanlizgu
Creator III
Creator III

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.

View solution in original post

3 Replies
lanlizgu
Creator III
Creator III

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
Contributor III
Contributor III
Author

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
Creator III
Creator III

Yes.