Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Distinct values in Dimension

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

Tags (2)
4 Replies
MVP
MVP

Re: Distinct values in Dimension

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

MonthName(YearMonth)

PFA

jyothish8807
Honored Contributor II

Re: Distinct values in Dimension

Hi Lathaa,

Try:

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

resident table;

Hope it works.

Regards

KC

Best Regards,
KC
Highlighted
rrsrini2907
Contributor

Re: Distinct values in Dimension

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.

MVP
MVP

Re: Distinct values in Dimension

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.

Community Browser