Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

set analysis

Hi,

Please find attached the qvf file.

i want to calculate the total sum with max(fmonthCD) and metrickeyid(1).

thanks

sunindia‌@

Tags (1)
3 Replies
balrajahlawat
Esteemed Contributor

Re: set analysis

mey be this?

=sum({<MetricKeyID={'1'}, fmonthCD={'$(=max(fmonthCD)'}>} Sales)

deepaktibhe
Valued Contributor

Re: set analysis

Try

=sum({<MetricKeyID={'1'}, fmonthCD={'$(=max(fmonthCD)'}>} Sales)

reddys310
Honored Contributor II

Re: set analysis

Hi Prashanth,

Try this:

=sum({<MetricKeyID={'1'}, fmonthCD={'=$(=max(fmonthCD)'}>} Sales)

Community Browser