Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I use the '*' character as a character and not a wild card?

In this first example, all records with field ABC = 'C' are selected and processed.

                           'C : ' & num(sum ({$< OrderFlag = {1}, trnstatus_uid = {1}, [Text(abc)] = {C} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price ))/

                         sum ({$< OrderFlag = {1}, trnstatus_uid = {1} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price )),'#0%')

Here I want to process records with ABC ='*'; However the character '*' is interpreted as a wild card returning all records.

                    '* : ' & num(sum ({$< OrderFlag = {1}, trnstatus_uid = {1}, [Text(abc)] = {'*'} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price ))/

                    sum ({$< OrderFlag = {1}, trnstatus_uid = {1} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price )),'#0%')

What should I do to select only the record with ABC = '*'

1 Reply
swuehl
MVP
MVP

Try

[Text(abc)] = {"=[Text(abc)]='*' "}