Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

it is possible design QV without using initial select button ?

Hi All

After play for QS for quite some time , and also aware QS does not allow user for add button for initial select. This make me think that QS try to force developer dont rely on button , so that user don't need to click , and directly can view the report.

So may i said that if i design QV from start , it is good habit for no using button. Any comment ?

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: it is possible design QV without using initial select button ?

I assume you mean a selection that must be made before the user can start interacting with the document?

My models never use an initial selection button. Normally there is a defined value of the relevant selections that you can use before the users make any selections For example, display the amounts as of the last transaction date.

A simple example:

Define a globally evaluated variable:

Set vMaxDate = '=Date(Max(TransDate))'

This will get the most recent date and store it in vMaxDate. If the user later makes a selection, the variable will recalculate automatiacally.

Then, in your sheet object expressions, use the set expression {<TransDate = {'$(vMaxDate)'}>}.

For example:

Sum({<TransDate = {'$(vMaxDate)'}>} Amount)


You could also add vMaxDate to the chart title or caption:

='Sales - ' & vMaxDate


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
6 Replies
andrespa
Valued Contributor

Re: it is possible design QV without using initial select button ?

Hi Paul, could you please clarify a bit your question? I don't understand it.

Cheers,

Andrés

sureshqv
Esteemed Contributor III

Re: it is possible design QV without using initial select button ?

are talking about  using link u want to open ur qvw?

awhitfield
Esteemed Contributor

Re: it is possible design QV without using initial select button ?

Sorry Paul, it's not clear what you are asking for

Andy

Re: it is possible design QV without using initial select button ?

please elaborate your requirement ...

MVP
MVP

Re: it is possible design QV without using initial select button ?

I assume you mean a selection that must be made before the user can start interacting with the document?

My models never use an initial selection button. Normally there is a defined value of the relevant selections that you can use before the users make any selections For example, display the amounts as of the last transaction date.

A simple example:

Define a globally evaluated variable:

Set vMaxDate = '=Date(Max(TransDate))'

This will get the most recent date and store it in vMaxDate. If the user later makes a selection, the variable will recalculate automatiacally.

Then, in your sheet object expressions, use the set expression {<TransDate = {'$(vMaxDate)'}>}.

For example:

Sum({<TransDate = {'$(vMaxDate)'}>} Amount)


You could also add vMaxDate to the chart title or caption:

='Sales - ' & vMaxDate


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
paulyeo11
Valued Contributor II

Re: it is possible design QV without using initial select button ?

Hi Jonathan

Great to hear that you give me the answer i hope to received. Thank you very much. So now i have found the right person to help me answer my following question :-

Your example share on using SET analysis to get YTD sales with out select on month and year i can understand. ( The only draw back is user is not able to view the last compare to previous year sales right ?  just to know if user request for such info how you handle ? )

Secondly in case the QV app required to handle multiple country , so user need to display org and SGD default currency. meaning all country is able to display their orginal currency or convert to SGD currency. Can you share how you handle this ?

Also you never create var like ColumnDim in your QV app , may i know if for the same SET table you need to different dynamic dimension by Brand or segment and Dynamic Expression on sales and profit analysis how you manage them ? 

Hope you can share with me.

Paul

Community Browser