Current Month

[#1]

I have loaded excel data to my qlikview document:

LOAD

ApplyMap('MapMonth',Month) as Month_Num

[Returns %],

Target

Which gives me a table that looks like this:

Month_Num     Returns %   Target

6                         0%             50%

7                        62%            70%

8                        55%            80%

9                                          100%

10                                         100%

11                                          100%

12                                           100%

How do I get the current months info to display in my chart for returns value.

Ie.  Today I would want it to say 55% without any selection.

It should always show the value in the current month.

Thanks

[MayilVahanan]

Hi

Try like this

=Sum({1<Month_Num  = {$(=Month(Today()))}>}[Returns %])

[lironbaram]

you can do something like

=max({<Month_Num={"$(=max({<"[Return %]={">0"}>}Month_Num))"}>}[Return %])

[#4]

Thank you for your prompt reply. However I only get 0% for this expression

- not the value

for August (8)

On 4 August 2015 at 10:57, Mayil Vahanan Ramasamy <qcwebmaster@qlikview.com>

[MayilVahanan]

Hi

Try like this

=Only({1<Month_Num  = {'$(=Num(Month(Today())))'}>}[Returns %])

[sunny_talwar]

You can also try this:

=Only({<Month_Num = {"$(=Max({<[Return %] = {'*?'}>}Month))"}>} [Return %])

[sasiparupudi1 · Accepted solution]

=Sum({1<Month_Num  = {$(=num(Month(Today())))}>}[Returns %])

[jagan]

Hi,

In Number tab Select the Number format to Fixed to 2 Decimals and select %.

Regards,

Jagan.

[#9]

Worked perfectly Sasidhar - thank you.