Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add a field "promotion" in QlikSense.
The Data source form connected to the SQL Server, and not this field, it is necessary to filter out the database from the required, as a new field "promotion"
The SQLQuery is
SELECT Max(IndexValue),CASE_NO,Subject
FROM [Members_Report_DYN_Batch] Where GroupName='MarketIndex'
GROUP BY CASE_NO,IndexValue,Subject
So how do I write the script regular statements?
Thanks in advance for any help!
Sample:
Load *
Max(IndexValue),
Case_No,
subject
....From
where GroupName='MarketIndex' ;
Hi Yang,
Your statement is not clear.. elaborate with an example if possible.
are looking to load the sql statement in qlikview
Load *
sql SELECT Max(IndexValue),CASE_NO,Subject
FROM [Members_Report_DYN_Batch] Where GroupName='MarketIndex'
GROUP BY CASE_NO,IndexValue,Subject;
I am not at all sure what you are asking, but there is a problem with your SQL: you would not normally group by the field you are using in the Max function:
SELECT Max(IndexValue),CASE_NO,Subject
FROM [Members_Report_DYN_Batch] Where GroupName='MarketIndex'
GROUP BY CASE_NO,IndexValue,Subject
I suggest that you post some clear examples of what you are hoping to achieve.
put ; after Load *
It should be
Load *;
sql select Max(IndexVale) .........
Try this
load * ;
Sql select
Max(IndexValue),CASE_NO,Subject
FROM [Members_Report_DYN_Batch] Where GroupName='MarketIndex'
GROUP BY CASE_NO,IndexValue,Subject;
Try this:
load *
SQL Select Max(IndexValue) as IndexValue,CASE_NO,Subject
From "yulon_10e".dbo."Members_Report_DYN_Batch"
where GroupName = 'MarketIndex'
Group by CASE_NO,Subject;