Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am not getting distinct Values in dimension - Line chart.
I have attached the .qvw - In tat look the second line chart I want to display PercentageofClaim for every YYYYMM. I think I have done some mistake in table joining..Please help me out!!!
Try calculated dimension(or, similarly at the script) like:
MonthName(YearMonth)
PFA
Hi Lathaa,
Try:
Load Distinct Date(Yourfield,'YYYYDD') as Yeardate
resident table;
Hope it works.
Regards
KC
Hi,
The actual problem is, the BOLEndDate is not converted to the month year. If you convert the YearMonth, it will give the actual date.
So kindly follow the below function to create YearMonth field in line 6 in Main 2 tab.
"Date(MonthStart(YearMonth),'YYYYMM')"
This will solve your problem.
Regards,
Srini.
Hi,
Try this script
Actual_Temp:
LOAD TotalSumInsured_USD,
LossEstimate_USD,
SumInsured,
LossEstimate,
Date(MonthStart(BOLEndDate),'YYYYMM') as YearMonth
FROM
(ooxml, embedded labels, table is SeaModeVarSectTest2);
Final:
LOAD YearMonth,
Sum(TotalSumInsured_USD) as AS ,
Sum(LossEstimate_USD) as AL ,
Sum(SumInsured) as PS,
Sum(LossEstimate) as PL
Resident Actual
Group by YearMonth;
Drop table Actual;
Regards,
Jagan.