topic Re: Qlik Sense API/SDK in Integration, Extension & APIs

Qlik Sense API/SDK

PRB6803 — Mon, 15 Feb 2021 09:10:54 GMT

I have written a visual studio (VB.NET) app to extract all master dimensions and measures from a select QS App. I then created a set of default Master Dimensions and Measures that can be applied based on field names to any selected App.

My problem is that when you add a master dimension that is an expression e.g. If(Approved = 1, 'Yes', 'No') the QS engine adds square brackets which causes the expression to fail. I tried quite a while thinking there was something I was adding in the text list in visual studio however when I extract the master items having created my own, the expression does not have square brackets around it.

Is there something I am missing an indicator etc. when I create the dimension?

Thank you in advance

Patrick

Re: Qlik Sense API/SDK

Øystein_Kolsrud — Mon, 15 Feb 2021 13:59:23 GMT

You probably need to add the character '=' in front of the expression. That indicates to the engine that this is a calculated dimension and not a field reference.

Re: Qlik Sense API/SDK

PRB6803 — Mon, 15 Feb 2021 16:36:59 GMT

Thank you so much worked immediately, just need to identify for myself now wether it's purely a field or a calculated dimension which is easy.

Really appreciate your prompt response