topic Re: Expression Syntax in QlikView

Expression Syntax

Wed, 03 Sep 2014 13:52:54 GMT

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

NickHoff — Wed, 03 Sep 2014 13:56:20 GMT

use set analysis:

COUNT({$<ID_TYPE >= {'501'}, ID_TYPE <= {'515]}>}ID)

MK_QSL — Wed, 03 Sep 2014 14:00:53 GMT

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;

NickHoff — Wed, 03 Sep 2014 15:00:30 GMT

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

maxgro — Wed, 03 Sep 2014 16:11:14 GMT

= count({$ <id_type ={">=501<=515"}>} ID)

Thu, 04 Sep 2014 14:12:51 GMT

Thank you. My issue is now resolved