Hello Everyone.

[#1]

Hello everyone,

I am new to qlikview , working on a pivot table ,

which after selection hiding all the other unselected data, while i want to show all the data after selection also.

please help me,

I am using sum({1}{<col1='A',col2='B'>}numbers) in my expression.

and it is not working.

Thanks.

[#2]

hi

try this

sum({1}{<col1='A',col2='B',Dimension=>}numbers)

i hope it helps

Gernan

[#3]

Hello Gernan ,

Thanks for reply,

Please tell me if i am using multiple expession like above in my pivot table then i need to give this condition in all my expressions.

Like expression 1 is sum({1}{<col1='A',col2='B'>}numbers)

expression 2 is sum({1}{<col3='001',col4='004'>}numbers) and 2 more expressions are there...

[#4]

Please refer the attached application

[er_mohit]

Try this

sum({1}{<col1={'A'},col2={'B'}>}numbers)

[#6]

Hii Mohit ,

Thanks for reply,

I already used this method in my expression but it is not working,

[#7]

can you attached picture ?

[jagan]

Hi,

If you want to exclude selection of all the fields then use {1} in your expression

sum({1}{<col1={'A'},col2={'B'}>}numbers)

If you want to exclude only certain fields then you need to specifically exclude that

sum({<col1={'A'},col2={'B'},  DimensionName=>}numbers)

You need to do the same for all the expressions individually, so that only it reflects.

Regards,

Jagan.

[#9]

This is (unselected data) pivot table. in which my dimension is ancestorname,  and i have some calculations in prior year expression which will show some value after selection of year in year list box, before selection it will show 0 like as below...so i am using sum({<ancestorname=>}moneymeasure) it is showing me only the selected value not the whole data

[#10]

Hii Jagan,

Thanks for reply.

This method is not working properly.

I have attached an image in this question , please tell me if there is any other answer which can be applied in this case.