topic Re: Problem regarding selection/unselection in QlikView

Problem regarding selection/unselection

sarfaraz_sheikh — Wed, 11 Feb 2015 08:08:01 GMT

Dear All,

I have 5 dimentional pivot table.When i click on 2nd level dimension then i will get all the associated data but the movement after i release the selection from 2nd level dimension then the selection is not releasing.

For more clarity have the look on attached snapshot.

belew snapshot is whithout selection on complaint

below is selected one ...once i selected over complain the movment after i will unselect the complain then it should be release as of now it is not happening.

Kindly help if any clue solution ......It is important.

My QVW is also attached here for your refernce.

Sarfaraz

Re: Problem regarding selection/unselection

alexandros17 — Wed, 11 Feb 2015 08:17:56 GMT

The reason is because with your dimensions every time you select in the second column there is more tha one selections, take a look to the version I attached ...

Let me know

Re: Problem regarding selection/unselection

sarfaraz_sheikh — Wed, 11 Feb 2015 09:19:23 GMT

Dear Alessandro,

Still i am facing same problem...kindly help !!!

Sarfaraz

Re: Problem regarding selection/unselection

sarfaraz_sheikh — Wed, 11 Feb 2015 09:22:37 GMT

I understood the problem....once once i click over dimension .,..more than one selection is happening...How i can remove the same ....

Sarfaraz

Re: Problem regarding selection/unselection

alexandros17 — Wed, 11 Feb 2015 09:29:27 GMT

Move your dimension condition in the script creating a new field and use that field as your dimension

let me know

Re: Problem regarding selection/unselection

sarfaraz_sheikh — Wed, 11 Feb 2015 09:47:42 GMT

Dear Alessandro,

Great Solution...Thanks a lot as of now it is working fine ........However one more query to ask you

Can i obtain top 10 on the basis of classification master column wise...have look on below sbnapshot.

Sarfaraz

Re: Problem regarding selection/unselection

alexandros17 — Wed, 11 Feb 2015 09:52:36 GMT

After dimension tab there is a "dimension Limit " tab, use it to show top 10 ...

Let me know and ... if the answer is correct could you please mark it?

Thanks

Re: Problem regarding selection/unselection

sarfaraz_sheikh — Wed, 11 Feb 2015 10:24:34 GMT

Dear Alessandro,

In pivot table there is no dimension limit tab, on dimension tab .......Thats the reason i asked you

Safaraz