Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have dimension which has few rows which I want to show only on the end of list. I use ListBox to show this dimension and in its Expression Sort I use sth like this:
if([Produkt] = 'BRAK',Count ([Produkt])+1,
if([Produkt] = 'Brak',Count ([Produkt])+2,
if([Produkt] = 'Niewykorzystany',Count ([Produkt])+3)))
And this expression allows me to show this special rows on the end. But when I select any other row, the sort of rows is changing and I don't know why and how to prevent this action.
The options which I use in sort are:
-State,
-Expression,
-Text.
I've also noticed that when I uncheck Text option, my rule works, but then order is not alphabetical.
Any hints will be very appreciated.
Monika
if I understand
=-wildmatch(only({1} Produkt), 'Niewykorzystany', 'BRAK', 'Brak', '*')
if I understand
=-wildmatch(only({1} Produkt), 'Niewykorzystany', 'BRAK', 'Brak', '*')
Hey, it works*! Thanks.
Please tell me one more thing. How does work this wildmatch?
*almost - I had to replace
=-wildmatch
with
(-1)*wildmatch
from Qlik help
wildmatch( str, expr1 [ , expr2,...exprN ] )
The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.
Example:
wildmatch( M, 'ja*','fe?','mar')
returns 1 if M = January
returns 2 if M = fex
It should works in the same way if you drop the minus and sort the expression descending