Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
jonathandienst
Partner - Champion III
Partner - Champion III

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

View solution in original post

6 Replies
andrespa
Specialist
Specialist

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

Cheers,

Andrés

Chanty4u
MVP
MVP

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

awhitfield
Partner - Champion
Partner - Champion

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

Andy

avinashelite

please elaborate your requirement ...

jonathandienst
Partner - Champion III
Partner - Champion III

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

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