Dynamic n qualifier number in CROSSTABLE

[laura_1]

Hi, 

Is it possible to usera variable to dynamically determine n qualifier number for CROSSTABLE function? I have used a variable and it transposes the table correctly, but QS underlines the whole table in red as if there is an error:

[laura_1]

Is there a way around this? 

Thanks for your help,

Laura 

[martyginqo]

Hello,

I'm in the same boat. I believe it still works with a dynamic value, but it still highlights as though it is a syntax error. This is always disconcerting.

[Gui_Approbato]

Hello,

Have you tried using single quotes to call the variable? Like Crosstable(Column,Values, '$(vVariable)')

[martyginqo]

Thanks for the suggestion - with quotes there's still a syntax error. The original syntax from initial post does actually run ... it's just this flagging as a syntax error which bugs me to no end. Qlik Sense seems more "fussy" than QlikView, which handles this syntax just fine.

Martin.