Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

AK

Hi there


I'm new to Qlik, I created a new app...


Now, I want to be able to "populate / fill in" a field (in a table that's part of one of the sheets)


As you know, the available expressions are: Sum,avg...etc. Instead, I want to to select a specific set of one of the fields... this is something similar to the Select statement in SQL with the "where" condition.... I tried the "Load" statement (inside the expression editor of the sheet) but it did not work

P.S: this field will have to be read from a connection to an Excel file


Any assistance will be appreciated

1 Solution

Accepted Solutions
Luminary
Luminary

Re: AK

Use set analysis in the expression editor e.g.

sum({<Field1={'Value1'}>} Metric)

This would be equal to

LOAD

sum(Metric)

From Table

where Field1=Value1;

8 Replies
amit_saini
Honored Contributor III

Re: AK

Hi,

Like this???

LOAD Country,

     City,

     Pin,

     Marks

FROM

(biff, embedded labels, table is Sheet1$)

where Match(City,'DELHI','PUNE');

OR

LOAD Country,

     City,

     Pin,

     Marks

FROM

(biff, embedded labels, table is Sheet1$)

where Pin='560059';

Still not sure what exactly you are looking for , please share ur source data and output you are looking for with an small example.

Thanks,

AS

Not applicable

Re: AK

Many thanks AS, still does not work... I'm not sure if the script you provided can be used as an expression (i.e. as an "Fx" in the data expression in while editing a sheet or should be used in the Load editor). Please advise

Luminary
Luminary

Re: AK

Use set analysis in the expression editor e.g.

sum({<Field1={'Value1'}>} Metric)

This would be equal to

LOAD

sum(Metric)

From Table

where Field1=Value1;

Not applicable

Re: AK

The code is working in the data load editor but it creates a new sheet...would prefer to "restrict" the inclusion of specific records through the expression editor other than the data load editor. In other words, is there an equivalent to the SQL "select ...where" that can be applied in the expression editor

Luminary
Luminary

Re: AK

Have you checked my post?

Not applicable

Re: AK

Thanks Martin, I did try your script but again it does not work... Please note that I'm trying to "select" using the "expression editor" not the "Load Editor"

Thanks in advance

Luminary
Luminary

Re: AK

Would be helpful if you could attach some screenshots of your expression editor.

Not applicable

Re: AK

Thanks Martin,

What you advised is the correct answer

Community Browser