topic Re: How to find value in pivot table.? in QlikView

How to find value in pivot table.?

Wed, 13 May 2015 03:46:32 GMT

Dear All,

How can i find a specific value in a pivot table?

For an example,

A B C D

1 5 7 8

2 4 6 4

3 2 5 3

4 2 4 4

5 4 3 3

6 2 6 4

If i want to find the Value '4' in this table, how could i able to do this?

Rgds,

Priyantha.

Re: How to find value in pivot table.?

sushil353 — Wed, 13 May 2015 04:19:27 GMT

Hi,

Your query is not clear.. explain with an example.

Re: How to find value in pivot table.?

qlikviewwizard — Wed, 13 May 2015 05:12:34 GMT

Hi pbandara,

WHat is your requirement?

Can you explain with an example?

Re: How to find value in pivot table.?

kavita25 — Wed, 13 May 2015 05:17:21 GMT

Hi...

Kindly explain in detail with expected result...

Regards,

Kavita

Re: How to find value in pivot table.?

Anonymous — Wed, 13 May 2015 05:30:50 GMT

Hi Priyantha,

if I have correctly understood your query then following will help you understand qv objects.

you can not search a single number/character in all the dimensions and expressions of pivot table nor in the straight table

you can use dropdown and then search in that particular dimension

and you can use search object but search object is for whole document or alternate state or specific field you have mentioned in it and is not part of straight table

Re: How to find value in pivot table.?

Wed, 13 May 2015 09:32:26 GMT

Example is there.. Just i want to search a specific value in my pivot table.

Priyantha.

Re: How to find value in pivot table.?

Wed, 13 May 2015 09:32:58 GMT

Example is there.. Just i want to search a specific value in my pivot table.

Priyantha.

Re: How to find value in pivot table.?

Wed, 13 May 2015 09:33:29 GMT

Example is there.. Just i want to search a specific value in my pivot table.

Priyantha.

Re: How to find value in pivot table.?

avinashelite — Wed, 13 May 2015 09:38:21 GMT

Hi,

You cannot search any specific values in the Pivot table, to search for a specific values you can try with adding the global search object , which will pop up you with all the field which have the string your searching for.