Solved: Re: Enable Expression Conditional in AJAX - Qlik Community

dcmcderm · ‎2014-10-21

I have a straight table that has several columns. Above each column I put a button to toggle whether or not to display the column. I did it this way:

-Create a variable for each column (ie "showColumn1")

-The button toggles the variable from 0-1 on click

-In the table, I have the Conditional set to =showColumn1

This works great using the local QV client. However when I post the file on our QV server, it does not work for end users on the AccessPoint using AJAX. What am I missing?

phaneendra_kunc · ‎2014-10-21

in QV10 there is no concept of conditional dimensions/expressions to show or hide them.

are you hiding Expression columns or Dimensions columns.

If expression columns then use same variable in "Presentation tab" in Conditional box. Using the same variable on dimensions doesn't make sense. as it wont re aggregate to that level.

If you want to show or hide the dimensions, for short term you have to create multiple straight tables with the combination and use the "Conditional show/hide" object in "layout tab".

View solution in original post

phaneendra_kunc · ‎2014-10-21

What is your QV version?

If possible can you post a sample app that has this problem.

JonnyPoole · ‎2014-10-21

in the desktop client does it work if you toggle to web view mode from the 'view' menu ?

dcmcderm · ‎2014-10-21

It does NOT work using webview in the desktop client.

dcmcderm · ‎2014-10-21

We are using QV Server 10, and my desktop client is 11.2. I suppose upgrading to QVS 11.2 might fix it but that's not a short term option so that's why I'm looking for other solutions.

Oh and I can't easily post a sample file, there is some sensitive data in it and I would have to scrub it first.

phaneendra_kunc · ‎2014-10-21

in QV10 there is no concept of conditional dimensions/expressions to show or hide them.

are you hiding Expression columns or Dimensions columns.

If expression columns then use same variable in "Presentation tab" in Conditional box. Using the same variable on dimensions doesn't make sense. as it wont re aggregate to that level.

If you want to show or hide the dimensions, for short term you have to create multiple straight tables with the combination and use the "Conditional show/hide" object in "layout tab".

dcmcderm · ‎2014-10-21

Thanks, It is expressions I'm trying to toggle so this might work. I'll try it and report back. I wonder why they would have this setting in 2 places?

EDIT - It worked! Thanks for the quick response.

phaneendra_kunc · ‎2014-10-21

QV10 - Under Presentation tab - Conditional:

This option will hide the column, but the qlikview chart will compute results for that column. Some cases it is not necessary to do that unless user wants that column on the chart. -- Kind of performance degrade.

QV11.2 - Under expression tab/Dimensions tab - Conditional:

This option will hide the column and also doesn't add that column to the computation. Some cases it improves the performance.