Expression already add filter , How to avoid manual filter ?

paulyeo11 — Sat, 04 May 2013 07:14:12 GMT

Hi All

I have a GL Table , when i select 2012 and Dec , it will display all GL_CODE on Table 1. Mt expression as below :-

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"}, month = ,year=>}[Amount])), $(vCurrency)))

Now i when Press button on Step 2 , it will filter those GL Code i need , and display at the result at Table 2. My expression as below :-

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"},[GL_CODE] = {"50030","50060","50016","50010","50011","50022","50040","50020","50090"}, month = ,year=>}[Amount])), $(vCurrency)))

Now my question is , with out user click on Step 2 button , how to make Table 2 appear ? Now user need to press button step 2 , my aim is avoid user press button step 2. Since in my expression already filter those GL CODE. which is same as press button.

Paul

Re: Expression already add filter , How to avoid manual filter ?

swuehl — Sat, 04 May 2013 11:24:00 GMT

Maybe like attached?

Re: Expression already add filter , How to avoid manual filter ?

paulyeo11 — Sat, 04 May 2013 19:55:02 GMT

Hi Stefan

Thank you very much for your help. It work now.

Paul

topic Re: Expression already add filter , How to avoid manual filter ? in QlikView

Expression already add filter , How to avoid manual filter ?

Re: Expression already add filter , How to avoid manual filter ?

Re: Expression already add filter , How to avoid manual filter ?