open document

[soniasweety]

Hi ALl,

i have  year,month,quarter fields ... now my requirment is  when user open the document  it should be open  

max year and max quarter ...that related months.  

and same way  

the clear button  when user click it should come to default state means --max year  and max quarter to be selected as wel,

thanks

sony

[soniasweety]

one quick question.. fiscal month is coming as text... how to change it to num?

i tried num(filed) as field but its not working

[ruben_antelo · Accepted solution]

Hi,

you could try with month(<expression>) that will return month if <expression> is a date.

MonthName() would do the opposite effect, by the way.

If it is not working, you can do it in script or create a date and after that, ask for a month: 

month(makedate(year,month,day))

There are a lot of possibilities to achieve your needs.

BR,

Rubén Antelo

[soniasweety]

thanks  Ruben_antelo

Albert_guito

one more issue i see... user want  all selected and related values are with green checkbox.. how to achieve this?

modified qvw check atatched.  

now i can see green selected in year and quarter  but user need in month filter also related values as green sleection

[ruben_antelo · Accepted solution]

Well... it is not the common way to work with QlikView, but with a simple modification in button "Start" and trigger on "Document On Open" this can be achieved.

Take a look at this attachment.

Best regards,

Rubén Antelo

[soniasweety]

thanks both.. its working

[soniasweety]

Hi Ruben_antelo   its showing green in listboxes  for only default selections only... 😞 

when user select on 2017  that is not showing in green selections 😞

[ruben_antelo]

Hi again!

Making a small change in document triggers, this document attached will select all available months if you change Year or Quarter.

Try it, I think it is what you are looking for.

Best regards,

Rubén Antelo

[soniasweety]

in fiscal quarter its not showing 😞 ..

[ruben_antelo]

Hi again,

Better approach here.

BR,

Rubén Antelo

[soniasweety]

Hi still i can see same issue 😞 in your latest qvw