Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Exprssion Help

=count({<[Year of Expense] =  {"$(vCurrentYear)"},

               [Month of Expense]={'Jan'},

               Keyplatopco = {"=sum([Expense Amount (USD)]*12) < 75000"},

               [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )



This logic was working until I added Month of Expense = Jan.


Keplatopco is calculated as below,

AutoNumber(RecordId&Year([Payment Date])) as Keyplatopco


do I need to add Month as well to Keyplatopco ?


AutoNumber(RecordId&Year([Payment Date])&Month([Payment Date])) as Keyplatopco



Any help is appreciated.


Thank you.

1 Solution

Accepted Solutions
sunny_talwar

Then adding month might make sense or try this

=count({<[Year of Expense] =  {"$(vCurrentYear)"},

               [Month of Expense]={'Jan'},

               Keyplatopco = {"=sum({<[Month of Expense]={'Jan'}>}[Expense Amount (USD)]*12) < 75000"},

               [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )

View solution in original post

7 Replies
vishsaggi
Champion III
Champion III

Can you try this?

=count({<[Year of Expense] =  {'$(vCurrentYear)'},

              [Month of Expense]={'Jan'},

              Keyplatopco = {"=$(= sum([Expense Amount (USD)]*12) < 75000)"},

              [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )

sunny_talwar

Is this condition checked at the Month level?

=sum([Expense Amount (USD)]*12) < 75000

sunny_talwar

I don't think dollar sign expansion is needed here... this is a search string which has to be between double quotes

apthansh
Creator
Creator
Author

ya...checking this condition at current year and then the Month level as for Month of Jan.

sunny_talwar

Then adding month might make sense or try this

=count({<[Year of Expense] =  {"$(vCurrentYear)"},

               [Month of Expense]={'Jan'},

               Keyplatopco = {"=sum({<[Month of Expense]={'Jan'}>}[Expense Amount (USD)]*12) < 75000"},

               [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )

sasiparupudi1
Master III
Master III

what is the format of the value in [Month of Expense]

?

apthansh
Creator
Creator
Author

Thank you as always