topic Current month and YTD in QlikView

Current month and YTD

qlik_venu — Wed, 19 Oct 2011 15:05:19 GMT

hi ,

We have a time Dimension in our database and this table is connected to the FACT table.

so we have indicators for the Current month, YTD, PYTD etc already available in the TIMe Dimension.

I have brought the columns Cuurent month, YTD into the qlikview.

But i need to provide this as a selction window for the users, so that they will be able to select ' YTD', current month etc. since these are seperate columns in the TIME dimension, i might not be able to bring them in a single list box selection.

so i thought of hiding the captions and then arranging the objects for each lists one below the other.

This works fine in data filtering.

But when i select Current month and then go on to select the YTD, both the list fiels are ACTIVE. I need to clear the other list as soon as I select the value.

Please let me know how this can be done or we can altogether change the approach for this.

thanks,

Venu

Current month and YTD

jedgson — Wed, 19 Oct 2011 15:13:28 GMT

Venu,

You could use a trigger to clear the field you want to remove the selection from.

Settings >> Document Properties >> Field Event Triggers

You can use an 'OnChange' trigger

use the action type 'Selection' and action 'clear other fields'

Jay

Re: Current month and YTD

john_duffy — Wed, 19 Oct 2011 15:36:09 GMT

Hi Venu.

I have attached a sample app in which I create a Time Measure table. This table simply contains the different types of time measurements (Curr Month, YTD, etc.) linked to the Fact table. In this example Product is the link.

I created a single list box using the Time Measurement table with the 'Always One Selected Value' option set. The Month list box is created using an expression to link the time measurement values to the Fact table.

Let me know if this helps.

John.

Current month and YTD

qlik_venu — Thu, 20 Oct 2011 11:25:30 GMT

Thanks Jay, this worked as expected.