topic Re: Quiz Question-1 in QlikView

Quiz Question-1

Tue, 07 Jul 2015 04:27:17 GMT

Hi All,

Lets start an QlikView Quiz. Will keep asking new question each day and will see who all are answering correctly with proper explanation.

Today's Question:

What is sort by applicability?

Sorting Field Values by Expression
Sorting Field Values by Possible Values
Sorting Fields by Possible Field Values in Multibox
This Sorting option is not available in QlikView
All of the above

Re: Quiz Question-1

Anonymous — Tue, 07 Jul 2015 04:48:20 GMT

Hi,

I think it is

Sorting Fields by Possible Field Values in Multibox

Re: Quiz Question-1

Anonymous — Tue, 07 Jul 2015 04:52:52 GMT

Sorts the fields in the multi box according to whether they contain possible field values or not. Fields lacking possible field values are dynamically moved down if the check box is marked.

Re: Quiz Question-1

Tue, 07 Jul 2015 04:58:21 GMT

Hi,

So you mean to say that If a field is not having possible value it will be moved down.

Suppose I have 3 fields:

Field-1 (Year)

Field-2 (Quarter)

Field-3 (Month)

Can you explain what will happen in this case. When I select Quarter 4 (where we have only 2015 data available)

Re: Quiz Question-1

krishna20 — Tue, 07 Jul 2015 05:09:03 GMT

Hi,

It is the property which belongs to multibox.

Sorting Fields by Possible Field Values in Multibox

Re: Quiz Question-1

robert_mika — Tue, 07 Jul 2015 05:33:22 GMT

Nice idea.

One suggestion.

You can create a pool which probably suit this kind of activity better

Re: Quiz Question-1

Tue, 07 Jul 2015 05:52:35 GMT

Hi Robert,

Do you mean Poll?

Please suggest which one needs to create for this activity?

Re: Quiz Question-1

robert_mika — Tue, 07 Jul 2015 05:58:49 GMT

Sorry a typo.

Yes - poll.(the one you have highlighted.)

Re: Quiz Question-1

Chanty4u — Tue, 07 Jul 2015 06:12:29 GMT

hi'

i think

Sorting Field Values by Possible Values is correct answer.

depending on values dat are applicable we can sort.

Thanks ,

Chanty

Re: Quiz Question-1

Tue, 07 Jul 2015 06:27:00 GMT

Here I have created Poll for QlikView Quiz.

Each day will create new Quiz Questions.

Re: Quiz Question-1

avinashelite — Tue, 07 Jul 2015 06:32:41 GMT

Sorting Fields by Possible Field Values in Multibox is the correct answer

Re: Quiz Question-1

qlikviewwizard — Tue, 07 Jul 2015 07:06:30 GMT

Hi Avinashelite ,

How? Please explain.

Re: Quiz Question-1

avinashelite — Tue, 07 Jul 2015 07:42:32 GMT

Sort by Applicability When this option is checked, the sort order of the Fields Displayed in Multibox

will be dynamically updated during selections so that fields with nonexcluded

field values will move upwards in the list while fields without possible

values will move downwards. This option will in many cases make it possible

to use literally hundreds of fields in a single multi box.

Re: Quiz Question-1

qlikviewwizard — Wed, 08 Jul 2015 02:03:18 GMT

Hi Avinashelite,

Thank you.