topic Re: Displaying Data for Current Month when no selection is made in QlikView

Displaying Data for Current Month when no selection is made

Thu, 23 Oct 2014 14:11:55 GMT

Hello,

I am currently creating a sales report. Being fairly new to Qlikview, I have tried different options to make sure the data that is displayed is the one for the current month, current year when nothing is selected but nothing I have tried is working.

I am trying this in my set analysis but its not working [Month] = ('$(=Month(max(Date)))')

Any suggestions?

Thanks

Re: Displaying Data for Current Month when no selection is made

Anonymous — Thu, 23 Oct 2014 14:13:53 GMT

Here's a sales example:

sum({1<Year={'$(=Max(Year))'},Month={'$(=Max(Month))'}>}Sales)

Re: Displaying Data for Current Month when no selection is made

alexandros17 — Thu, 23 Oct 2014 14:14:34 GMT

Try this:

[Month] = ('$(=Month(Today()))')

let me know

Re: Displaying Data for Current Month when no selection is made

Thu, 23 Oct 2014 14:19:35 GMT

In sheet properties - Triggers- OnActiveSheet-Add Actions- add-Select Infield- Field As 'Year ' -Search String as ' =Year(Today(1))' will give you the current year by default each time you open the sheet..

Same with Month but Search String would be '=Month(Today(1))'

Hope it helps.

Re: Displaying Data for Current Month when no selection is made

Anonymous — Thu, 23 Oct 2014 14:22:40 GMT

Wouldn't that potentially impact selections that the application user wanted to maintain? I would (and do) use something like this when the document is first opened, but I wouldn't set this at the sheet level.

Re: Displaying Data for Current Month when no selection is made

Thu, 23 Oct 2014 14:30:12 GMT

Steve, I have tried your suggestions but no data is coming up.

Alessandro, It is working but then if I do select a month, the data doesn't update to the selected month. Is there a way around that?

Sandhya, I have done that and it is giving me what I want but as Steve mentioned, every time I come back to that sheet, my selection resets to current Year, Current Month. How can I set that up when the document is first opened?

Re: Displaying Data for Current Month when no selection is made

alexandros17 — Thu, 23 Oct 2014 14:35:53 GMT

Dear Tomas,

set analysis filter data and no selection will change your visualization.

To show a month at first and then change it do as follow:

1) Settings -> document properties -> triggers

2) click "on open" -> edit action -> Add

3) in the field write your field name so in your case: Month

4) in the search string write: =Month(Today())

Save the document and open it again and ... let me know

Re: Displaying Data for Current Month when no selection is made

Thu, 23 Oct 2014 14:43:05 GMT

Thanks Alessandro, it worked well!

Re: Displaying Data for Current Month when no selection is made

alexandros17 — Thu, 23 Oct 2014 14:44:26 GMT

If you could mark my answer ... thank you!!!