topic Re: Month problem in QlikView

Month problem

vipin_mishra479 — Tue, 08 May 2012 11:45:00 GMT

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

Re: Month problem

Anonymous — Tue, 08 May 2012 12:05:36 GMT

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)

Re: Month problem

vipin_mishra479 — Tue, 08 May 2012 12:42:33 GMT

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

Re: Month problem

Tue, 08 May 2012 12:57:59 GMT

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

.....

Re: Month problem

vipin_mishra479 — Wed, 09 May 2012 05:30:30 GMT

Thanks Mr. rav1234 its workable..