Error in Quarter wise data selection

[deepakqlikview_123]

Hi All,

Please find attached QVW file.

My quarter wise data selection is not working properly.

April data is displayed in 3 quarters.Moreover there is also requirement to show data date wise Please suggest.

Thanks,

[SergeyMak]

First of all you need to change your script

Calendar:

load

DealerID

resident OrganisationMaster;

Left Join

LOAD

DealerID,

You should change to

Calendar:

LOAD DISTINCT

your further script

because you don't need DealedId in this table and you need only unique records of dates.

Your "Q" appeared because for some records you don't have DealerInvoiceDate. You just have to decide what you need to do in this case.

But you didn't generate the calendar, you just move dates to another table

please read carefully  http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

and try to get the powerful calendar

[deepakqlikview_123]

Hi Seregy,

I do not want to display only 'Q' But still I am not able to understand what action I need to in this case.

Can you please suggest.

Thanks,

Deepak

[SergeyMak]

If you create a normal calendar it will disappear.

But if you don't want just add after Resident Retail

WHERE isNull(DealerInvoiceDate)=0;

But in any case you will not be able to see your data if DealerInvoiceDate without value.

You should have filled KEY field

[deepakqlikview_123]

In My ccode if Diesel or SIESEL then i need to show only 1 field as Diesel,

and if LPG then LPG and if CNG then CNG

Actually I am drill down to detail level so use this code in script

if(FuelType='Diesel' or FuelType='DIESEL','Diesel',If(FuelType='LPG','LPG',If(FuelType='CNG','CNG')))as FuelType,

[deepakqlikview_123]

Hi Seregy,

I have used

month(if(isnull(date(UpdatedOn)) or date(UpdatedOn)='-', date(DealerToDealerInvoiceDate,'DD-MM-YYYY'), date(UpdatedOn,'DD-MM-YYYY'))) as Retail_Month,

Condition because in my table where updated on in null then I have to use DealerToDealerInvoiceDate otherwise i have to use UpdatedOn.

If this is not right idea for creation of month date then,

by using only DealerInvoiceDate will it be show proper results after generating calendar.

Please suggest.

Thanks,

Deepak

[SergeyMak]

You can add new calculated field

if(isnull(date(UpdatedOn)) or date(UpdatedOn)='-', date(DealerToDealerInvoiceDate,'DD-MM-YYYY'), date(UpdatedOn,'DD-MM-YYYY')) AS Calculated.Date

build calendar based on this new date and connect to this date Calendar table

[deepakqlikview_123]

Hi Seregy,

I want to remove all record starting from DI99 can you please tell me what will be condition for this.

Thanks,

Deepak