Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

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

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
Creator III
Creator III
Author

The date fields are from two seperate tables:

(Message Login Date) = (Calendar Month Name)

Thanks,

H

Not applicable

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