topic AW:Static step in slider object in QlikView

Static step in slider object

Mon, 21 Feb 2011 13:18:56 GMT

Hi all,

I've a problem with the slider object. The purchases and sales data has a corresponding date. What I want is to create an slide in which only to select months, not days. I've created an slider and link it to the date field but if I move the selector, the selection is for only 1 day and what I want is to select the month, what can I do?

Thanks for your time and sorry my bad english.

Greetings,

Miguel.

AW:Static step in slider object

Mon, 21 Feb 2011 13:40:21 GMT

Hello Miguel,

instead of using the date field itself, you can use an expression derived from this field. See Slider properties --> general tab --> pull down menü ---> choose last entry (in english: <expression>). Then you are able to input an expression similar to

=Year(SalesDate & '-' & Month(SalesDate)

Another (better) way would be to create this "rolling MonthYear" as a seperate field within your loadscript.

Regards, Roland

AW:Static step in slider object

Mon, 21 Feb 2011 15:59:20 GMT

Thank you Roland! It works! I've tested the expression and it works perfectly.