topic Re: RE:Strange behaviour in QlikView

RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 14:57:54 GMT

hi all,

I have an issue with Current selection box.

The issue is : i have one stright table and that related values also available in other sheet also.

So i select one value in stright table in other sheet the current selections shwng as two selected values?

how to overcome this?

Thanks in advance

suresh

Re: RE:Strange behaviour

sunny_talwar — Wed, 02 Mar 2016 14:59:34 GMT

Can you share a screenshot of what you seeing?

Re: RE:Strange behaviour

awhitfield — Wed, 02 Mar 2016 15:00:16 GMT

Interesting, please upload an example qvw.

Andy

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 15:10:41 GMT

hi sunny,

chk the images

Re: RE:Strange behaviour

awhitfield — Wed, 02 Mar 2016 15:13:31 GMT

Ha ha! They must be the SMALLEST screen shots in the world

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 15:20:34 GMT

The value that you select in your "stright" table is a calculated dimension based on prj_id and Project1 ?

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 15:22:00 GMT

sry...i dnt knw y it i shwng small?

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 15:27:05 GMT

yes that is dnamic table....and hvng onselect trigger aswell

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 15:28:43 GMT

Is more clear with bigger image 😉

If you select a value, the dimension that define the row will be selected.

If you clik in your "stright" table directly on a dimension, normally only this dimension will be selected

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 15:35:10 GMT

wen i select on dimensions it is shwng in current selecction box as one selection only.....other than that it is shwng 2selections?

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 15:43:47 GMT

Hi fatoux,

thnks for u.stdng the issue

Is there any option to ovrcome this? please help me out?

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 15:50:49 GMT

You could not only authorised the selection in dimensions of a table, but you could unauthorized selection globaly on the table (Table properties --> General --> Read Only).

I don't know if its what you want?

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 15:55:06 GMT

Or you could remove the dimension "prj_id" and add a new measure Only(prj_id) and finally moved it manually before "Project1".

You will have only one dimension that could be selected

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 15:56:02 GMT

thnks for reply....

wen i chk read only.

it is not allowng to select anythng in table?

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 16:04:29 GMT

Yes, that's exactly what I said, that's why I did not think that this solution will go for you.

Have you try my second solution?

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 16:05:05 GMT

yes fatoux....its wrkng fyn..... but wen i add measure as only(prj_id) in stright table its shwng values as null symbol like "-" ?

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 16:07:33 GMT

hmmm yes exctly...............

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 16:11:48 GMT

Strange that signify that they are multiple value for "prj_id", for one "Project1". Only the return the value if unique or Null instead.

Is it true?

Re: RE:Strange behaviour

Chanty4u — Wed, 02 Mar 2016 16:13:04 GMT

how to get that values instead of nulls?

Re: RE:Strange behaviour

sfatoux72 — Wed, 02 Mar 2016 16:14:26 GMT

try to do the opposite:

Remove the dimension "Project1" and add a new measure Only(Project1) and finally moved it manually before "prj_id".