This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am creating a dynamic text box based on filters on product and country.
I want something like 'You are now looking at sales for "product" from "country".'
The filter then decides which country and product is mentioned in the text box.
My problem is, that if all product are shown (hence, there is no filter on "product"), then I don't know the filter syntax.
I tried something like the following
If(Product = null(), 'all products', Product), but the "null()" is incorrect. So my question is, what is the syntax for a non-filtered filter?
There are too many products to mention them all in a combined if-statement.
You can try this
If(Len(Trim(Product)) = 0, 'all products', Product)
If(IsNull(Product)), 'all products', Product)
If(GetSelectCount(Product)) = 0, 'all products', Product)
View solution in original post
Solution number 2 worked perfectly!