topic Month wise data in qlikview in QlikView

Month wise data in qlikview

Sat, 08 Aug 2015 06:42:46 GMT

Dear Experts ,

I am designing month wise account reports ,but i am getting same value for all months .

For Example assume i have an data from 201404 to 201508 . in my report i want to display data for four months from 201504 to 201507 .

If my month value is 201504 , then i want to sum of 201404 to 201504 .

if my month value is 201505 , then i want to sum of 201404 to 201505 .... but i am getting same value for all months . please suggest .

In my report for apr month value 201504 will be 95511.31 , but i am getting -182474 for all four months .

PrashantSangle — Sat, 08 Aug 2015 07:24:17 GMT

Hi,

Check your variable definition.

I think TOTAL_REV_LOCAL_AMOUNT and TOTAL_REV_CORPORATE_AMOUNT

are fields not string so when define in variable mention it like

if(Curr='LOCAL',TOTAL_REV_LOCAL_AMOUNT,TOTAL_REV_CORPORATE_AMOUNT)

not

if(Curr='LOCAL','TOTAL_REV_LOCAL_AMOUNT','TOTAL_REV_CORPORATE_AMOUNT') // Dont use single quote .

Might be this help you.

Regards

Sat, 08 Aug 2015 08:53:55 GMT

HI Max Dreamer ,

Thanks for your reply

Its not working , i am getting null values if i remove single quote .

svenkita — Sun, 09 Aug 2015 01:58:10 GMT

hi sriram

kindly correct the environment variable

if you go to the script editor

and check .. you have currently used the following

SET DateFormat='DD-Mon-YYYY';

if you want the Month to be as JAN, Feb ... in the data use the following

SET DateFormat='DD-MMM-YYYY';

In your "Test Data" pivot chart

expression of "201504"

New Formula

=if(Curr='LOCAL',

Sum({< TB_MONTH= {"<=$(=MonthEnd(MakeDate(2015,05,01)))"} >}TOTAL_REV_LOCAL_AMOUNT),

Sum({< TB_MONTH= {"<=$(=MonthEnd(MakeDate(2015,05,01)))"} >}TOTAL_REV_CORPORATE_AMOUNT)

)