topic Re: Selections in QlikView

Selections

Anonymous — Thu, 13 Aug 2015 10:15:06 GMT

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

Re: Selections

Gysbert_Wassenaar — Thu, 13 Aug 2015 10:22:28 GMT

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

Re: Selections

Anonymous — Thu, 13 Aug 2015 10:30:25 GMT

Selections on list box and calendar

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

Re: Selections

avinashelite — Thu, 13 Aug 2015 10:43:11 GMT

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;

Re: Selections

Anonymous — Thu, 13 Aug 2015 10:52:14 GMT

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;

Re: Selections

Anonymous — Thu, 13 Aug 2015 11:10:13 GMT

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

Thanks

Re: Selections

avinashelite — Thu, 13 Aug 2015 11:19:32 GMT

please share the qvw and the sample data will check

Re: Selections

Anonymous — Thu, 13 Aug 2015 11:21:54 GMT

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

Re: Selections

avinashelite — Thu, 13 Aug 2015 12:00:12 GMT

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

Re: Selections

Anonymous — Thu, 13 Aug 2015 12:11:07 GMT

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