topic Re: To show the latest Month expression in App Development

To show the latest Month expression

prabunakil — Mon, 13 Aug 2018 03:13:02 GMT

Hi, i have a table to show the net sales.

the table include of field name, transactionmonth1, net sales.

What is the expression in the straight table i can set to show the net sales always show in current month (Latest Month).

eg: now is August, the net sales showing is aug sales. next month is sept, net sales show is september.

Please advise.

Re: To show the latest Month expression

sibin_jacob — Mon, 13 Aug 2018 06:11:41 GMT

Write the transactionmonth1 dimension like below

if(transactionmonth1= Date(max(Date#(transactionmonth1,'MMM')),'MMM'),transactionmonth1)

Then Check on the suppress when value is null.

I am assuming the transactionmonth1 value formats are Jan,Feb, Mar etc

Re: To show the latest Month expression

shraddha_g — Mon, 13 Aug 2018 06:13:34 GMT

Try,

sum({<transactionmonth1 = {"$(=max(transactionmonth1))"}>} [Net Sales])

Re: To show the latest Month expression

arvind1494 — Mon, 13 Aug 2018 06:23:58 GMT

Hi Prabu

Check the attached qvf

Re: To show the latest Month expression

prabunakil — Wed, 15 Aug 2018 06:13:14 GMT

Can i have it in qvw file?

Re: To show the latest Month expression

prabunakil — Wed, 15 Aug 2018 06:13:24 GMT

Hi it Did not work

Re: To show the latest Month expression

Arthur_Fong — Wed, 15 Aug 2018 06:29:58 GMT

Hi Prabu,

Check if transactionmonth1 is a numeric field or text field.

If it is a numeric field, shraddha.g solution should work.

Drag a filter panel out and insert transactionmonth1 into the filter panel.

Then check if the months in transactionmonth1 is left-aligned or right-aligned.

Thanks and regards,

Arthur Fong

Re: To show the latest Month expression

sibin_jacob — Wed, 15 Aug 2018 06:57:13 GMT

As Arvind Suggested,

Use the dimension as

=Month(Today())

and expression

=sum({<transactionmonth1 ={$(=Month(Today()))}>}[net sales])

Re: To show the latest Month expression

BalaBhaskar_Qlik — Wed, 15 Aug 2018 08:29:35 GMT

May be this:

=sum({$<transactionmonth1 = {"=$(=Month(Today()))"}>}NetSales)

=SUM({$<transactionmonth1={'$(=max(vCurrMonth))'}>}NetSales)

LET vCurrMonth = month(transactionmonth1);

Re: To show the latest Month expression

prabunakil — Thu, 16 Aug 2018 03:07:42 GMT

is a numeric field

Re: To show the latest Month expression

prabunakil — Thu, 16 Aug 2018 03:13:31 GMT

this expression put in where?

Re: To show the latest Month expression

Arthur_Fong — Thu, 16 Aug 2018 04:20:32 GMT

Hi Prabu,

Refer attached is the sample to show the current month in table.

Thanks and regards,

Arthur Fong