topic Re: Count of a Calculated Measure in QlikView

Count of a Calculated Measure

arpita — Sat, 06 Mar 2021 15:09:26 GMT

I have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please help

TLMMO:

LOAD
SET_ID,
IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID

FROM
$(file)

Re: Count of a Calculated Measure

Or — Sat, 06 Mar 2021 20:17:13 GMT

Why not Count(CCY_SETID)?

Re: Count of a Calculated Measure

Saravanan_Desingh — Sun, 07 Mar 2021 00:27:14 GMT

Try this,

TLMMO: LOAD SET_ID, IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID FROM $(file) ; Left Join(TLMMO) LOAD SET_ID, Count(CCY_SETID) As Cnt Resident TLMMO Group By SET_ID;

Re: Count of a Calculated Measure

arpita — Tue, 09 Mar 2021 11:14:17 GMT

Hi saran,

This doesnt work

Re: Count of a Calculated Measure

arpita — Thu, 11 Mar 2021 15:37:59 GMT

I have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please help

TLMMO:

LOAD
SET_ID,
IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID

FROM
$(file)

Re: Count of a Calculated Measure

MayilVahanan — Fri, 12 Mar 2021 04:28:17 GMT

Are you looking something like

Count(Total CCY_SETID)

If not, Can you provide sample data n expected output.

Re: Count of a Calculated Measure

arpita — Fri, 12 Mar 2021 07:48:03 GMT

Hi Mayil, this doenst work in script