topic Re: QSB: Exporting to Excel issue in Management & Governance

QSB: Exporting to Excel issue

jsteyn — Sat, 16 Nov 2024 03:14:23 GMT

Hi Guys

Straight forward issue I picked up when exporting a pivot to excel.

I have some columns that only shows based on the value of a variable, when viewing through my browser I see the expected columns when the value of the variable is changed, but when exporting to excel all columns get exported regardless if the condition is true or false in the "Show column if"

Regards

Re: QSB: Exporting to Excel issue

nisha_rai — Tue, 18 Feb 2020 10:21:56 GMT

Hi,

Can you please share the screenshot/ sample data.

Re: QSB: Exporting to Excel issue

jsteyn — Tue, 18 Feb 2020 14:25:30 GMT

Please see images below.

I also tried by wrapping my variable in single quotes on the "Show Column if", ie. '$(vIncludeCount)' vs. $(vIncludeCount) with no success.

Funny thing is when i force the expression to 1=0 and then try to export those columns they are omitted, so not sure if the fault is on my end or Qlik...

Re: QSB: Exporting to Excel issue

nisha_rai — Tue, 18 Feb 2020 12:22:05 GMT

Can you try if($(variable name)=1,1,0),may be it helps

Re: QSB: Exporting to Excel issue

jsteyn — Tue, 18 Feb 2020 12:43:59 GMT

thanks for the prompt response @nisha_rai , unfortunately this is not a solution,

I have tried multiple scenarios without success, namely:

=if($(vIncludeCount)=1,1,0)

=if('$(vIncludeCount)'=1,1,0)

=if($(vIncludeCount)=1,1=1,1=0)

=if('$(vIncludeCount)'=1,1=1,1=0)

=if('$(vIncludeCount)'='1',1=1,1=0)

Strange thing is the expression without the if statement, ie. 1=0 works by omitting the columns when downloading