Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Date Format

Hi All,

I am having a Date1 field in Date table, which contains the date in below format:

11/15/2014 11:10:00 AM

Now in dashboard, I am fetching Month and Year from Date1 field by using month and year function like: Month(Date1) and Year(Date1).

Everything is working fine but from Month or Year filters when I select any value then in current selection box it showing some numbers.

Please see below image:

Date1.png

Please help me to fix this.

Thanks.

5 Replies
Highlighted

Re: Date Format

Hi,

It will show the number of rows selected for that month that is NOV month and it seems any other selection is there with month selection.

Regards

Anand

Highlighted
Partner
Partner

Re: Date Format

Hi Soha1902,

I take it, you have derived Month and Year in the listboxes as expressions, that is why Current Selection Box show the number of associated values you have derived/selected from Date1.

If you would move the Month and Year function into Script level and save them as fields, this should fix your issue, otherwise, that is normal behavior.

Highlighted
Creator
Creator

Re: Date Format

Hi Anand,

But I want to show selected month or year in current selection box.

Please let me, how I'll get this?

Thanks.

Highlighted
Not applicable

Re: Date Format

Hi,

Move the expressions to script and use them in the list box instead of creating expression in the list box itself.

BR,

Neha

Highlighted

Re: Date Format

Hi,

Yes you can but not all dates in the current selection if the rows are more it will show some thing

Dateselection.png

And it show density of the rows also in the front end right bottom side of the Qlikview application.

desity.png

Regards

Anand