Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

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

Try

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

Community Browser