QSB: Exporting to Excel issue

[jsteyn]

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

[nisha_rai]

Hi,

Can you please share the screenshot/ sample data.

[jsteyn]

Hi 

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

1

2

34

[nisha_rai]

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

[jsteyn]

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