topic Re: Current month in QlikView

Current month

Wed, 25 Nov 2020 16:16:04 GMT

Hello again.....

I have a bar chart with a selection box to click and view data for each month

JAN, FEB etc.

Can I make the chart display the current months results as a default

until the user makes a month selection ?

Re: Current month

Chanty4u — Wed, 20 Apr 2016 11:19:23 GMT

u can use bookmark for that.

Re: Current month

avinashelite — Wed, 20 Apr 2016 11:21:38 GMT

yes you can try like this .

If(getselectedcount(field_name)=0 and field_name=month(today()), field_name,field_name)

Re: Current month

sunny_talwar — Wed, 20 Apr 2016 11:29:05 GMT

May be like this:

If(GetSelectedCount(Month) = 0, Sum({<Month = {"=Num(Month) = Max(TOTAL Month)"}>}Sales), Sum(Sales))

Re: Current month

oscar_ortiz — Wed, 20 Apr 2016 17:34:51 GMT

To go along with what @Avinash R and sunindia‌ were saying I like to store my Current Month as a variable then use the variable in my expression. I think it makes for an easier expression.

Re: Current month

johnw — Wed, 20 Apr 2016 18:25:52 GMT

If the user can only look at one month at a time, maybe set up the list box that way, and select the current month by default using a trigger when they open the application. That affects the whole application, of course, not just one bar chart.