Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vipin_mishra479
Creator II
Creator II

Month problem

i want to show current month on my chart for that i have use today() function it come to current month but when i select any other month it not change then what logic we use in my chart it with out any selection it show current month and when i select other month it show that month

1 Solution

Accepted Solutions
Not applicable

Hi Mishra,

Try this

=if(Count(GetFieldSelections(MonthField))>0,MonthField,Month(Today()))

in the Title Text of the Chart.

Where MonthField is the field contains Monthes information from your side.So relace it with your field name.

hope it helps you

regards

.....

View solution in original post

4 Replies
Anonymous
Not applicable

You want to show the current month, but when you select an other month you want to show an other month? Am I right?

If so, make a selectionbox for month, select one month and go to the properties of that selection box and check "Always One Selected Value"  (optional)

Then go to Settings >> Document propeties >> tab: Triggers

Add an Action OnOpen

Add >> Selection in Field

Field : YourMonthField

Search String : =Month(Today())

This way when you open your document the current month get selected.

Is that what you are looking for?

(You can also add this trigger on Reload if you wish)

vipin_mishra479
Creator II
Creator II
Author

sir actualy i want to sales record current month wise eg. may - 2012 and when i select jan 2012  value are change but it show still may -2012 in my column

Not applicable

Hi Mishra,

Try this

=if(Count(GetFieldSelections(MonthField))>0,MonthField,Month(Today()))

in the Title Text of the Chart.

Where MonthField is the field contains Monthes information from your side.So relace it with your field name.

hope it helps you

regards

.....

vipin_mishra479
Creator II
Creator II
Author

Thanks Mr. rav1234 its workable..