Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

open document

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

Labels (1)
27 Replies
soniasweety
Master
Master
Author

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
Partner - Contributor III
Partner - Contributor III

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
Master
Master
Author

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
Partner - Contributor III
Partner - Contributor III

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
Master
Master
Author

thanks both.. its working
soniasweety
Master
Master
Author

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
Partner - Contributor III
Partner - Contributor III

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
Master
Master
Author

in fiscal quarter its not showing 😞 ..
ruben_antelo
Partner - Contributor III
Partner - Contributor III

Hi again,

 

Better approach here.

 

BR,

 

Rubén Antelo

soniasweety
Master
Master
Author

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