Discussion board where members can get started with Qlik Sense.
I would like to share with you this table.
i want to select only rows having ComplexTypeID=00000000-0000-0000-0000-000000000000 by this script:
select ComplexTypeID as CTID,Value from EventsTimelineDetail where ComplexTypeID='$(complexid)';
but as the result i got all three rows
What is wrong in the script!!!?
SET complexid = '00000000-0000-0000-0000-000000000000';
LOAD * Where CTID = '$(complexid)';
sql select ComplexTypeID as CTID, Value from EventsTimelineDetail;
Maybe the script is auto-concatenating the records to an already existing table with same number and name of fields?
Note that the table view says Battle_Event_Details while your script label tells EventTimeLinetable.
And also check if you need to use curly brackets around your ID filter value or not.