Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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
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;
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
Have you checked my post?
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
Would be helpful if you could attach some screenshots of your expression editor.
Thanks Martin,
What you advised is the correct answer