Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

miskin_m
Contributor

Qlik Data Concierge Variant issue with variable

Hi All,

I am trying to impelment the QDC with Qliksense and below are the issue I am find hard to resolve.

1. At the time of Bex query variable selection the year filed appears has 2018001.

2. Once this app is created, it shows no data loaded.

3. This is because the variable passed in query is wrong. For eg Below is the code

Set vAssistVar3=['2018001'];


Set vAssistVar4=['LA0008'];


for each var3 in $(vAssistVar3)

for each var4 in $(vAssistVar4)


....

VARIABLES (

[NAME=ZU_FSPER, SIGN=I, OPTION=EQ, LOW=$(var3)],

[NAME=ZUAD_PRCTR_1, SIGN=I, OPTION=EQ, LOW=$(var4)],

)

FROM query_name;


4. Once I change it manually like..


Set vAssistVar3=['V32018001'];

Set vAssistVar4=['1000LA0008'];

it runs perfectly.

This issue seems to be with every variables in Bex query

regards

Miskin

Community Browser