Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Static step in slider object

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.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

AW:Static step in slider object

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

2 Replies
Not applicable

AW:Static step in slider object

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

Not applicable

AW:Static step in slider object

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