topic Calculated-Dimension in QlikView

Calculated-Dimension

hkg_qlik — Thu, 14 Jun 2012 15:19:06 GMT

Hi,

Wanted to create a calculated dimension for:

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

Regards,

Thu, 14 Jun 2012 15:21:28 GMT

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 — Thu, 14 Jun 2012 15:27:44 GMT

The date fields are from two seperate tables:

(Message Login Date) = (Calendar Month Name)

Thanks,

Thu, 14 Jun 2012 15:29:41 GMT

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))