Selections

[Anonymous]

Hi all,

What could be the possible reasons for selections not getting applied in qlikview .

I have llist box calendar and text  box object.

If i select Date from calendar and Mtd,ytd or day from list box then values in text box should be appeared.

But in my case if i select date from calendar then selections get applied in textbox for different dates.Upto this my application is working good.But if i select mtd or ytd or day my selections are not getting applied ?

What could be the reason ?Any Help is appreciated

Thanks

[Gysbert_Wassenaar]

Impossible to tell for sure without being able to look at your document. Can you post a small qlikview document that demonstrates the problem?

[Anonymous]

Selections on list box and calendar

Hi

Please go through the above link .You will find my qvw document.

I should attach my document here but its taking long time to uplaod.

Thanks

[avinashelite]

hi ,

The data links are not proper , in your fact_Scales and call_timeGranule tables the date key are in different format . Convert them to same format as below:

Fact_Sales:

LOAD Date(DATE_KEY,'YYYYMMDD') as DATE_KEY

other columns

Call_TimeGranule :

load Date(TempDate,'YYYYMMDD') as DATE_KEY

Resident Cal;

[Anonymous]

Hi

i Tried with following script .still problem exits

Let varMinDate = Floor(WeekStart(Date#('01-01-2014', 'DD-MM-YYYY')));

Let varMaxDate = Floor(WeekEnd(Date#('31-07-2015', 'DD-MM-YYYY')));

Cal:

LOAD

$(varMinDate) + Iterno()-1 As Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

left Join(Cal)

load date(TempDate,'YYYYMMDD') as DATE_KEY

Resident Cal;

NoConcatenate

Cal_TimeGranule:

Load *, 'YTD' as TimeGranule

Resident Cal where DATE_KEY>= YearStart(TempDate) and DATE_KEY<=TempDate ;

//Bringing Accumulated MTD granule

Concatenate

Load *, 'MTD' as TimeGranule

Resident Cal where DATE_KEY >=monthstart(TempDate) and DATE_KEY<=TempDate;

//Bringing Accumulated Day granule

Concatenate

Load * , 'Day' as TimeGranule

Resident Cal

where DATE_KEY=TempDate;

DROP Table Cal;

CAL:

Load

      TempDate as CALDATE,

    Month(TempDate) as SALES_MONTH,

    Year(TempDate) as SALES_YEAR,

    MonthName(TempDate) as SALES_MONTHNAME,

    'Q' & Ceil(Month(TempDate)/3) AS SALES_QUARTER,

    DayNumberOfYear(TempDate) as DayNumberOfYear,

    Day(TempDate) as DayNumberOfMonth,

    DayNumberOfQuarter(TempDate) as DayNumberOfQuarter,

    num(Month(TempDate)) as MonthNum

    Resident Cal_TimeGranule;

[Anonymous]

Hi

Please find the attachment .i have made changes suggested by you. Stilll same issue,

Thanks

[avinashelite]

please share the qvw and the sample data will check

[Anonymous]

I have shared  my qvw file .Please look into the discussion.

[avinashelite]

As i check your getting the rite data only!!! can you please explain what is the exact output your looking for ??

so that we can understand the requirement ...check your MTD,YTD and Day calculation once because it all yields the same result

[Anonymous]

Hi,

My requirement is

I need to get the values for mtd,ytd and day values for particular date.

When i select date(let's assume 1/2/2014) from calendar and mtd or ytd or day(lets assume day) from time granule .My text box will display sum of sales for particular day.

Now for same date i.e 1/2/2014 if i select mtd my date in calendar object is getting cleared .I want it to be same unless i change the date.

Thanks