Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hkg_qlik
Contributor II

Calculated-Dimension

Hi,

Wanted to create a calculated dimension for:

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

Regards,

H

3 Replies
Not applicable

Re: Calculated-Dimension

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
Contributor II

Re: Calculated-Dimension

The date fields are from two seperate tables:

(Message Login Date) = (Calendar Month Name)

Thanks,

H

Not applicable

Re: Calculated-Dimension

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

Community Browser