Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a calculated field which I am trying to join with a Date field so that I might see it by date. Despite, both the fields used in the calculation being linked to a date field, I can't find a way to get the calculated field by date. The script I'm using is below:
CalculatedFields:
LOAD
Date,
SUM(Alpha* Beta) AS Charlie
RESIDENT SecurityData
group by
Date,
ProductID,
Alpha,
Beta
Charlie,
Delta
etc;
Any ideas how I can get the two to link?
I think this: you only have the Date field as non aggregated field, so you need to group by Date
CalculatedFields:
LOAD
Date,
SUM(Alpha* Beta) AS Charlie
RESIDENT SecurityData
group by
Date;
I think this: you only have the Date field as non aggregated field, so you need to group by Date
CalculatedFields:
LOAD
Date,
SUM(Alpha* Beta) AS Charlie
RESIDENT SecurityData
group by
Date;
Could you elaborate with some sample data lines of SecurityData (could be mock up data, but the structure should be comparable)?
Worked perfectly, thanks so much!
As a follow up question, how can I group by fields in another resident table?
in this script you're already group by from a table (SecurityData)
and the result is a new table (CalculatedFields)
CalculatedFields:
LOAD
Date,
SUM(Alpha* Beta) AS Charlie
RESIDENT SecurityData
group by Date;
maybe I don't understand your question
Apologies, I have loaded in two tables SecurityData and a second called SecurityCharacteristics which contains a field, for instance, of Region.
I want to be able to sort my calculated field by Region.
in Qlik you can sort (or group by) fields in one table
if you need to sort (or group by) fields from 2 tables, first you have to join the tables in a a new one
then do a resident load (with sort or group by) from the new one