topic Re: Current Month in QlikView

Current Month

Tue, 04 Aug 2015 09:54:16 GMT

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

Re: Current Month

MayilVahanan — Tue, 04 Aug 2015 09:56:47 GMT

Try like this

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

Re: Current Month

lironbaram — Tue, 04 Aug 2015 09:58:48 GMT

you can do something like

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

Re: Current Month

Tue, 04 Aug 2015 10:04:20 GMT

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>

Re: Current Month

MayilVahanan — Tue, 04 Aug 2015 10:20:55 GMT

Try like this

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

Re: Current Month

sunny_talwar — Tue, 04 Aug 2015 10:28:27 GMT

You can also try this:

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

Re: Current Month

sasiparupudi1 — Tue, 04 Aug 2015 10:32:19 GMT

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

Re: Current Month

jagan — Tue, 04 Aug 2015 11:07:50 GMT

Hi,

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

Regards,

Jagan.

Re: Current Month

Tue, 04 Aug 2015 12:23:42 GMT

Worked perfectly Sasidhar - thank you.