topic Distinct values in Dimension in QlikView

Distinct values in Dimension

Mon, 09 Mar 2015 04:46:09 GMT

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!!!

Re: Distinct values in Dimension

tresB — Mon, 09 Mar 2015 05:00:26 GMT

Try calculated dimension(or, similarly at the script) like:

MonthName(YearMonth)

PFA

Re: Distinct values in Dimension

jyothish8807 — Mon, 09 Mar 2015 06:38:55 GMT

Hi Lathaa,

Try:

Load Distinct Date(Yourfield,'YYYYDD') as Yeardate

resident table;

Hope it works.

Regards

Re: Distinct values in Dimension

rrsrini2907 — Mon, 09 Mar 2015 06:41:49 GMT

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.

Re: Distinct values in Dimension

jagan — Mon, 09 Mar 2015 06:48:56 GMT

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.