Calculated-Dimension

[hkg_qlik]

Hi,

Wanted to create a calculated dimension for:

Count the number of Message ID , if (Message Login Date) = (Calendar Month Name)

Regards,

H

[#2]

if they are in the same table use an if statement in your load scripti.e. if(MLD=CMN,1,0) then in the front end Sum that field

[hkg_qlik]

The date fields are from two seperate tables:

(Message Login Date) = (Calendar Month Name)

Thanks,

H

[#4]

Your expression should be something like Count({$<(Message Login Date) ={ (Calendar Month Name) }>} (Message Login Date))

or sum(if((Message Login Date) = (Calendar Month Name),1,0))