topic Re: Hello Everyone. in QlikView

Hello Everyone.

Fri, 18 Oct 2013 05:22:43 GMT

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.

Re: Hello Everyone.

Fri, 18 Oct 2013 05:26:59 GMT

try this

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

i hope it helps

Gernan

Re: Hello Everyone.

Fri, 18 Oct 2013 05:30:29 GMT

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...

Re: Hello Everyone.

Fri, 18 Oct 2013 05:31:37 GMT

Please refer the attached application

Re: Hello Everyone.

er_mohit — Fri, 18 Oct 2013 05:34:25 GMT

Try this

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

Re: Hello Everyone.

Fri, 18 Oct 2013 05:43:44 GMT

Hii Mohit ,

Thanks for reply,

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

Re: Hello Everyone.

Fri, 18 Oct 2013 05:47:34 GMT

can you attached picture ?

Re: Hello Everyone.

jagan — Fri, 18 Oct 2013 05:49:37 GMT

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.

Re: Hello Everyone.

Fri, 18 Oct 2013 06:49:42 GMT

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

Re: Hello Everyone.

Fri, 18 Oct 2013 06:51:34 GMT

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.

Re: Hello Everyone.

jagan — Fri, 18 Oct 2013 07:42:56 GMT

Hi,

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

Regards,

Jagan.

Re: Hello Everyone.

Fri, 18 Oct 2013 07:49:48 GMT

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)

Re: Hello Everyone.

Fri, 18 Oct 2013 09:30:18 GMT

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

Re: Hello Everyone.

Fri, 18 Oct 2013 09:33:24 GMT

ok try this,

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

Re: Hello Everyone.

Fri, 18 Oct 2013 09:50:35 GMT

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.

Re: Hello Everyone.

Fri, 18 Oct 2013 11:30:58 GMT

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...

Re: Hello Everyone.

Fri, 18 Oct 2013 11:33:44 GMT

Have you try this

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

Re: Hello Everyone.

Fri, 18 Oct 2013 11:45:42 GMT

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

Re: Hello Everyone.

Fri, 18 Oct 2013 11:48:58 GMT

ok include what what you want to add

Re: Hello Everyone.

Fri, 18 Oct 2013 12:23:15 GMT

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.