Set Analysis

[Vittore8]

Hello, please tell me what this entry means

A={'1*'}

if possible, with examples, I would be grateful

[Kushal_Chawda · Accepted solution]

This is nothing but the wildcard search within set analysis

Basically it says that filter the values from field A where values are starting with 1

Let's understand below scenario

load * inline [
Category,Sales
ABC,100
AAA,200
BBC,300
BAC,400 ];

Now, you have requirement where you want to show sales for the Category where Category names start with 'B' then you can write set analysis expression like below

=sum({<Category={"B*"}>}Sales)

you can further look at the wildcard search  here

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Text_search_and_numeric_...