Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Qlik Sense Select all

Hi, please tell me how to replace it, Select * from [table] where [column] = ".....";  to this expression, ={$<Age={20}>}

Labels (1)
1 Reply
Durgadevikumar
Partner
Partner

Hi Vittore,

Try this below,

TableA:

load

field1,

field2,     // Age should be one of the field among all the fileds

Field3,

.,.,.,., Fieldn

FROM
[C:\Users\Desktop\top 10 sales.xlsx]
(ooxml, embedded labels, table is Sheet2)

where Age = 20;

OR

while taking the resident load

load * resident TableA

where age = 20;

Hope it is useful...

Regards,

DurgadeviKumar