topic Re: open document in QlikView

open document

soniasweety — Sat, 16 Nov 2024 04:58:32 GMT

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

Re: open document

ruben_antelo — Thu, 13 Dec 2018 09:14:51 GMT

Hi,

Please take a look at your example in this post.

I have added a opening trigger in your document and changed triggers in your 'Clear' button.

Best regards,

Rubén Antelo

Re: open document

jonathandienst — Thu, 13 Dec 2018 09:21:59 GMT

If you include set expression in your metrics to get the latest possible date, there is no need to have automatic selections. When nothing is selected, the objects will display the most recent period, year, quarter or date (per your requirements). When you select a date (month, year, etc), then the objects will display the selected date.

Re: open document

soniasweety — Thu, 13 Dec 2018 09:19:51 GMT

but .. there is one issue am facing.. when clear all. its coming default state but .. when u de select 2018 and select 2017 0r 2016 and clik on clear button.. its showing that year max quarter and all

how to avoid that

Re: open document

ruben_antelo — Thu, 13 Dec 2018 09:23:25 GMT

Hi,

I have modified expressions, right now it is ok.

Problem was that expression max(Fiscal_Year) is under the scope of selections. If you have selected 2017, max is 2017. To avoid this, we put max({1} Fiscal_Year) that will override the scope of the function to all your data universe.

Best regards,

Rubén Antelo

Re: open document

soniasweety — Thu, 13 Dec 2018 09:26:27 GMT

but in fiscal month it shlud be selected 3 motnhs right? for max quarter 3 months will be there but now only one month is selected

Re: open document

albert_guito — Thu, 13 Dec 2018 09:33:55 GMT

Hi,

You have to use trigger, one in the documments properties and other in the button.

See the app attached with the triggers added.

Ag+

Re: open document

ruben_antelo — Thu, 13 Dec 2018 09:34:52 GMT

Sorry...

I understood max month. This is the good one.

Best regards,

Rubén Antelo

Re: open document

albert_guito — Thu, 13 Dec 2018 09:36:35 GMT

Consider the @ruben_antelo comments about the max({1} Fiscal_Year) , it's not included in the sample

Re: open document

soniasweety — Thu, 13 Dec 2018 09:39:08 GMT

thanks all let me try in my original app and come back to you guys

Re: open document

soniasweety — Thu, 13 Dec 2018 09:51:46 GMT

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

Re: open document

ruben_antelo — Thu, 13 Dec 2018 10:12:25 GMT

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

Re: open document

soniasweety — Thu, 13 Dec 2018 10:18:48 GMT

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

Re: open document

ruben_antelo — Thu, 13 Dec 2018 10:23:05 GMT

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

Re: open document

soniasweety — Thu, 13 Dec 2018 10:32:02 GMT

thanks both.. its working

Re: open document

soniasweety — Thu, 13 Dec 2018 11:11:18 GMT

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 😞

Re: open document

ruben_antelo — Thu, 13 Dec 2018 11:21:24 GMT

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

Re: open document

soniasweety — Thu, 13 Dec 2018 11:32:18 GMT

in fiscal quarter its not showing 😞 ..

Re: open document

ruben_antelo — Thu, 13 Dec 2018 11:33:07 GMT

Hi again,

Better approach here.

BR,

Rubén Antelo

Re: open document

soniasweety — Thu, 13 Dec 2018 11:40:17 GMT

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