topic Re: expression unshow in QlikView

expression unshow

Sat, 15 Aug 2015 18:11:14 GMT

Hi,

I need some inputs on the pivot table expression hide.

I need to hide the Actual column for FULL YEAR dimension.

the actual column for PERIOD & YEAR-TO-DATE should remain the same.

Any help would be highly appreciated!!!

Re: expression unshow

maximiliano_vel — Sat, 15 Aug 2015 18:22:56 GMT

If you only need not to show the result of Actual for FULL YEAR then perhaps you could try

=if([P&L ACCOUNT] <> null() and [P&L Level] <> 's' and valuelist('PERIOD', 'YEAR TO DATE','FULL YEAR')= 'PERIOD',sum({<month ={$(vMTDPeriod)}>}Actual),

if([P&L ACCOUNT] <> null() and [P&L Level] <> 's' and valuelist('PERIOD', 'YEAR TO DATE','FULL YEAR')= 'YEAR TO DATE',sum({1<Year ={$(vYTDYear)}>}Actual),

if([P&L ACCOUNT] <> null() and [P&L Level] <> 's' and valuelist('PERIOD', 'YEAR TO DATE','FULL YEAR')= 'FULL YEAR','','')))

Or Please post the expected results.

Regards

Re: expression unshow

antoniotiman — Sat, 15 Aug 2015 18:32:23 GMT

So, if I have understood like this

Re: expression unshow

Sat, 15 Aug 2015 18:32:41 GMT

Thanks for the quick response Maximiliano,

the values are not showing but the entire column should be deleted along with the columns

please look into the required output. look at the red colored circle on full year dimension

Re: expression unshow

Sat, 15 Aug 2015 18:56:50 GMT

could you please do help ?

Re: expression unshow

maximiliano_vel — Sat, 15 Aug 2015 19:25:53 GMT

I'm sorry is something Like this? Please elaborate...

Re: expression unshow

Sun, 16 Aug 2015 02:17:20 GMT

Hi Maximilinao,

please could you remove the complete column that i rounded with black colour?

Only the Actual column in Full Year has to be removed, the other columns in Full year has to remain as it is.

Re: expression unshow

Sun, 16 Aug 2015 03:29:29 GMT

bump

Re: expression unshow

maximiliano_vel — Sun, 16 Aug 2015 13:29:14 GMT

Hi, well i'm sorry to tell you that i didn't find a way to remove the column Actual ONLY for dimension FULL YEAR, the max i could get was zeroing the column Actual

When you remove the column Actual from the pivot table, it remove it from all dimensions.

Re: expression unshow

antoniotiman — Sun, 16 Aug 2015 14:29:47 GMT

I'm sorry, I agree too.

Regards

Re: expression unshow

jagan — Mon, 17 Aug 2015 02:48:40 GMT

Hi,

Please find attached file for solution.I did this for Actual and Budget you can try the other parameters.

Regards,

Jagan.

Re: expression unshow

Mon, 17 Aug 2015 06:29:32 GMT

hI Jagan

thanks for the suggestion unfortunaltey i tried the expression i am not able to generate the values

plese find the app where i have created formulas for other expression

Do needful

Re: expression unshow

jagan — Mon, 17 Aug 2015 09:11:08 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.