Discussion Board for collaboration on QlikView Scripting.
I have experience using sql.
In sql you can run:
if there were two employeees named 'Matt Smith' then the resulting data would be
Matt Smith 50kMatt Smith 47k
is there an equivalent of this in qlikview?
When I put 'where count(salary)>1', it says my execution failed.
Thanks for any help
Group By name;
if I am not pulling from a DB but am instead just pulling from an excel sheet is there still a way to apply sql?
doesnt matter you are pulling from a database or from a excel file or as a resident load.... whenever you are aggregating data in script, you have to use GROUP BY with those fields which are part of that load..
As far as I know, you cannot use aggregation function in where clause of QlikView script.
You can use the below method for your requirement
LOAD * Inline [
sum(Sal) as SalSum
Group by Emp;
DROP Table Fact;
DROP Table New;
you are not able to do that as far as I know, though you can do a preceding load
where ValueTotal < 2;
sum(value) as ValueTotal
Yes.. You can't use Group By and where together... I didn't notice that while answering... OK... you can use something like below.
Load * Where Salary > 125;
Load Name, SUM(Salary) as Salary Group By Name;
Load Name, Salary From FileName;
Hi Try this.
LOAD * where count(salary)>1;
sum(salary) as salary
group by name;
Try like this in Qlikview
WHERE salCount >1;
Count(Distinct salary) AS salCount
GROUP By name;
Hope this helps you.
Please close this thread if you got your answer by marking the correct one.