topic Re: Date Flag linking problem in QlikView

Date Flag linking problem

Wed, 12 Feb 2014 09:22:35 GMT

hi all,

PFA

i have a holiday list

through which i have calculated Net working days and all required things

then i i have created a calender for this year and using them in creating flag

but am getting one problem when taking holiday using apply map am not getting it correctly for For my Flag festival

when i select a State from dimension And then when i select Festival from Flag then it show very few dates or Count of Date

am think that this is apply map problem

how to solve it and how to create three flags? for my datei

flags = festival,

weekday,

weekend

Thanks in advance

Re: Date Flag linking problem

maneshkhottcpl — Wed, 12 Feb 2014 09:59:33 GMT

You can try attached file

Apply map is not necessary

Regards

Manesh

Re: Date Flag linking problem

MK_QSL — Wed, 12 Feb 2014 10:19:51 GMT

I haven't tried but you can try using below script..

Temp:

Mapping LOAD

State,

Date(Dates,'DD-MM-YYYY') as Dates

FROM

fest.xlsx

(ooxml, embedded labels, table is Sheet2);

//======================================================

Data:

LOAD State,

HoliDay,

Date(Dates,'DD-MM-YYYY') as Dates

FROM

fest.xlsx

(ooxml, embedded labels, table is Sheet2);

//======================================================

Join(Data)

Date_genration:

LOAD

Date(YearStart(Today()) + RecNo() - 1) as Dates

AutoGenerate Ceil(YearEnd(Today())) -YearStart(Today());

NoConcatenate

FinalTable:

Load

State,

Dates,

IF(IsNull(HoliDay) and WeekDay(Dates) = 'Sat', 'WeekEnd',

IF(IsNull(HoliDay) and WeekDay(Dates) = 'Sun', 'WeekEnd',

IF(Not IsNull(HoliDay), 'Festival',

'WeekDay'))) as flag_D

Resident Data;

Drop Table Temp;

Re: Date Flag linking problem

MK_QSL — Wed, 12 Feb 2014 10:25:02 GMT

Little update in the If statement is you want to calculate Festivals which are falling in WeekEnds.

IF(IsNull(HoliDay) and WeekDay(Dates) = 'Sat', 'WeekEnd',

IF(IsNull(HoliDay) and WeekDay(Dates) = 'Sun', 'WeekEnd',

IF(Not IsNull(HoliDay) and WeekDay(Dates) = 'Sat', 'WeekEndFestival',

IF(Not IsNull(HoliDay) and WeekDay(Dates) = 'Sun', 'WeekEndFestival',

IF(Not IsNull(HoliDay), 'Festival','WeekDay'))))) as flag_D

Re: Date Flag linking problem

Wed, 12 Feb 2014 10:31:10 GMT

but now when we select any state it does not gives any data about Week days and week ends

Re: Date Flag linking problem

MK_QSL — Wed, 12 Feb 2014 11:15:13 GMT

Please check enclosed file.

Hope this will help you

Re: Date Flag linking problem

MK_QSL — Wed, 12 Feb 2014 13:40:32 GMT

Hi, have you tried this?

Re: Date Flag linking problem

Wed, 12 Feb 2014 14:58:55 GMT

tried we need only three flags,

festival, weekend, Weekday,

how to get that

and Calculation of holidays per state not comming Correct

Re: Date Flag linking problem

MK_QSL — Wed, 12 Feb 2014 17:47:38 GMT

Let me know is it working for you or not?

Re: Date Flag linking problem

Thu, 13 Feb 2014 06:20:58 GMT

no its not working

Re: Date Flag linking problem

MK_QSL — Thu, 13 Feb 2014 06:32:53 GMT

Let me know what is coming wrong?

Give me an example.. will try my best to sort it out...

Re: Date Flag linking problem

Thu, 13 Feb 2014 06:48:57 GMT

it giving wrong result

Re: Date Flag linking problem

Thu, 13 Feb 2014 06:51:33 GMT

client need only three flags

Re: Date Flag linking problem

Thu, 13 Feb 2014 06:53:30 GMT

when i select state it only shows possible selection are only two in flag i.e Weekend festival and weekday

Re: Date Flag linking problem

MK_QSL — Thu, 13 Feb 2014 06:55:07 GMT

have you checked my last QVW ?

Re: Date Flag linking problem

MK_QSL — Thu, 13 Feb 2014 07:41:50 GMT

please check this one...