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.

[jagan]

Hi,

Can you attach some sample file, it helps in understanding the issue and solve it quickly.

Regards,

Jagan.

[#3]

Try This,

Exp 1:

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

Exp 2:

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

Exp3:

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

[#4]

Hii Nirmal ,

Thanks for Reply

values is not any kind of field in this , this is a calculated dimension as:

=if(match(AncestorId,'A','B','C','D','E'),AncestorName) and its label is Values

[#5]

ok try this,

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

[#6]

I did this also but my expression containing some value from ancestorid also ,i can't keep it blank like my expression contain 1 of variable for Fixed asset  less Accumulated Depreciation like:

=if(AncestorId='A',vFixedAsset,Sum({<AncestorId=,AncestorName=>}moneymeasures))

where vFixedAsset is

=sum({$<AncestorId={'P','Q','R'},str_pov_name={'ACTUAL'},AncestorName=>}money_measure)

similarly i have multiple conditions in my expression like above 1.

[#7]

Thanks Everyone , I am able to solve this problem.

The rest problem in this case is after selecting each value from the chart i donot want to show it on the top,

I want to show it always in its original place.

Means the order should not change in selecting values from dimension,

please help...

[#8]

Have you try this

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

[#9]

yes Nirmal I have tried this also , but some more fields need to be included in that.

[#10]

ok include what what you want to add

[#11]

Nirmal Can u please tell me the concept if i am writing code like:

if(only({<AncestorId=,str_coa_code=,str_fy=,AncestorName=,str_coa_description=>}AncestorId)='PAR007',prioryearfixed,sum(moneymeasure));

as i used this as a solution in expression

where prior year fixed is a valriable having some calculations.