Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts
I would like to convert the statement below to qlikview expression syntax
Select Count(ID) From Table1 Where id_type between 501 AND 515
Please assists
use set analysis:
COUNT({$<ID_TYPE >= {'501'}, ID_TYPE <= {'515]}>}ID)
use set analysis:
COUNT({$<ID_TYPE >= {'501'}, ID_TYPE <= {'515]}>}ID)
This is at the front end...
COUNT({$<id_type = {>=501<=515}>}ID)
This is at the front end (Script side)
Load ID,
Count(ID)
Resident TableName
Where id_type >=501 and id_type <= 515
Group By ID;
If that is the front end just create the ODBC connection and use SQL.
Directory;
TableName:
LOAD ID,
ID_TYPE;
OLEDB CONNECT TO
SQL
SELECT
ID, COUNT(ID) AS ID_TYPE
FROM TableName
WHERE ID_TYPE BETWEEN 501 and 515;
STORE TableName INTO the qvd you want
= count({$ <id_type ={">=501<=515"}>} ID)
Thank you. My issue is now resolved