Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a query in sql like below
select count(1) from Travel where to_char(start_date, 'YYYY')
in (2023) and cwt_jv_data_unique_id is null and cwt_data_unique_id is null and gbt_data_unique_id is null;
How to write this in qliksense
Hi, something like this, and then do a sum on field "NoOfRecords" in the front end.
TravelData:
LOAD *,
Count(DISTINCT NOR) as NoOfRecords
Group By start_date,
cwt_jv_data_unique_id,
cwt_data_unique_id,
gbt_data_unique_i,
NOR;
LOAD start_date,
cwt_jv_data_unique_id,
cwt_data_unique_id,
gbt_data_unique_i,
RowNo() as NOR
Where Year(start_date) = Year(today())
and Len(Trim(cwt_jv_data_unique_id & cwt_data_unique_id & gbt_data_unique_id )) = 0;
SQL SELECT *
FROM YourDatabase.dbo.Travel;