Qlik Sense Select all

[Vittore8]

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

[Durgadevikumar]

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