Discussion Board for collaboration related to QlikView App Development.
I know there are a lot of week to date (WTD), Month to date (MTD) and year to date (YTD) posts but i can not find anything that will fit my problem.
A sheet is loaded daily (see attached excel), from these figures I create the averages per channel using: -
which when you select a date or a range of dates does a calculation per channel.
That all works ok but i have been trying to set the charts to a fixed date rather than selecting a date. I have tried using triggers on opening, Duplicate tables, and my last attempt: -
then suppress all the zeros.
I have not used set analysis before but gave this a go but did not seem to do anything.
If anyone can recommend any ways to set my charts to Yesterday, WTD, MTD and YTD i would be very grateful.
sorry i worked it out in the end, the trigger that i had set were not working because my dates were a string rather than a date. Thanks for replying so fast.
View solution in original post
look at my little sample application with two OnOpening triggers on the field "Date". Is it that what you intended ?