topic Re: Fiscal Month based on Reporting Month in QlikView

Fiscal Month based on Reporting Month

vardhancse — Sun, 24 Jan 2016 10:30:35 GMT

Hi,

Have one small requirement is that in my dashboard created one variable

vReportingmonth= Month(AddMonths(ReloadTime(),-1))

And added in document trigger, so that when ever I open the dashboard the month will be reporting month.

Now the requirement is that,

2 fields:

Monthname, FiscalMonth

Oct, 1

Nov, 2

Dec, 3

Jan, 4

Feb, 5

Mar, 6

Apr, 7

May, 8

Jun, 9

Jul, 10

Aug, 11

Sep, 12

based on the reporting month the field fiscalmonth should be shown always the fiscal month of the reportingmonth

Re: Fiscal Month based on Reporting Month

MK_QSL — Sun, 24 Jan 2016 10:43:54 GMT

=Only({<Monthname = {"$(vReportingmonth)"}>}FiscalMonth)

Re: Fiscal Month based on Reporting Month

vardhancse — Sun, 24 Jan 2016 10:48:21 GMT

Hi Manish,

thanks for your reply, the above condition is fine but I am looking for some thing different.

Like , the FiscalMonth should be static, like whatever month selection I am doing in the dashboard the fiscalmonth text object should show only the reporting month fiscal month.

Sorry if i am not clear in my initial question.

Re: Fiscal Month based on Reporting Month

MK_QSL — Sun, 24 Jan 2016 10:53:56 GMT

=Only({1<Monthname = {"$(vReportingmonth)"}>}FiscalMonth)

Re: Fiscal Month based on Reporting Month

vardhancse — Sun, 24 Jan 2016 10:58:23 GMT

Sorry Manish, In my text object when I applied the =Only({1<Monthname = {"$(vReportingmonth)"}>}FiscalMonth)

Its showing -

Re: Fiscal Month based on Reporting Month

MK_QSL — Sun, 24 Jan 2016 11:01:35 GMT

Provide your sample app