Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ristrict data to be show on table

I have source table like this

authorityheadfiscal_ yeartype_idcommited_amtexpense

IA

4412002-2003L125005000
IA4412003-2004L1500500
IA

441

2009-2010

F$500$100

IA

4412010-2012F$6555$1200
IA4412012-2013L150003500
IA4412013-2014L2000100

I ONLY WANT TO SHOW A PIVOT TABLE IN QLIKVIEW

with all records of type_id= 'L' and Fiscal year except maximum which is  2013-2014 in my case and

note:

max_year is a variable having value 2013-2014 in it

KINLDY give a expression to achive in a pivote table

having a dimenions

=authority

=head

=fiscal_year

=type_id

expression

for commited amt is  =sum({$<type_id={'L'}>}commited_amt)

for expense   is  =sum({$<type_id={'L'}>}expense_amt)

how to show data not including 2013-2014 row ???

regards

Fady

3 Replies
Anonymous
Not applicable
Author

Shariq

Try replacing the standard dimension fiscal_year with a calculated dimension like::


     if ( fiscal_year = '2013-2014' , null() )


And do remember to check the checkbox "Suppress when value is null".



Best Regards,     Bill

Gysbert_Wassenaar

Add a constraint for fiscal_year to the set modifier:

    sum({$<type_id={'L'},[fiscal_ year]-={'$(max_year)'}>}commited_amt)

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi

when we use '-=' it exclude data

like this:

sum({$<type_id={'L'},[fiscal_ year]-={'2013-2014'}>}commited_amt)

this expression calculate commited_amt for all row except rows that have fiscal_ year=2013-2014

Best Regards