how to set flag ..

[Anonymous]

Hi Everyone ,

Here I'm attaching  qvw and excel file . in this I have count totalworking days, total noworking days and total festival.

by using the applymap function .  but i'm facing problem when we select the date then total working days show negative value.

and i want to implement three flag weekdays, weekend and holidays according to these flags the totalworking days, total noworking days and total festival should be change . I was try bt I think that is not correct. I'm not able to do that thing bcz I'm new in qlikview .

please anyone help me to complete this requirement.

Thanks

[#2]

Hi Dhiraj,

Its not the matter of positive or negative, the data what it is displaying is correct?

when you select the date (01-01-2014), the total working days is -2,total non working days 3 and total weekend 1.

was this data is correct?

Regards,

rajesh.

[Anonymous]

Hi Rajesh,

But here I 'm strucking  that how to implement flag of weekdays, Weekend and Holidays..