topic Exprssion Help in QlikView

Exprssion Help

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

=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.

vishsaggi — Thu, 23 Mar 2017 18:44:44 GMT

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 — Thu, 23 Mar 2017 18:47:37 GMT

Is this condition checked at the Month level?

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

sunny_talwar — Thu, 23 Mar 2017 18:48:09 GMT

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

apthansh — Thu, 23 Mar 2017 18:51:09 GMT

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

sunny_talwar — Thu, 23 Mar 2017 19:01:01 GMT

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 — Fri, 24 Mar 2017 12:31:39 GMT

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

apthansh — Mon, 27 Mar 2017 21:02:27 GMT

Thank you as always