topic Issue with variable in set expression - Qlik sense in App Development

Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 18:14:47 GMT

Hi ,

I need your help guys,

I have a variable named : vIsPreviousPeriode

When I use this variable in a set expression to feed a column in a table objet, I don't get the good result ! (all the time 0 value !!!)

1. First I calculate the vIsPreviousPeriode

2. I use this syntax : =SUM({$<Myfield = {$(=vIsPreviousPeriode)}>} Mymeasure)

Re: Issue with variable in set expression - Qlik sense

sunny_talwar — Tue, 22 Aug 2017 18:15:48 GMT

What is Myfield? and how do you define your variable?

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 18:21:29 GMT

When I write the value's string for testing, iI have athe right response :

=SUM({$<Myfield = {"JUN-17"}>} Mymeasure) ===> Ok.

=SUM({$<Myfield = {$(=vIsPreviousPeriode)}>} Mymeasure) ===> 0 (wrong)!

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 18:22:10 GMT

MyField is a field in my logical table

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 18:23:55 GMT

vIsPreviousPeriode is a variable defined in varibales Editor (Qlik Sense)

Re: Issue with variable in set expression - Qlik sense

sunny_talwar — Tue, 22 Aug 2017 18:24:01 GMT

Is MyField read as a date field by QlikView or Qlik Sense (whichever you are using)?

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 18:32:01 GMT

MyField is a string (Qlik Sense)

Re: Issue with variable in set expression - Qlik sense

sunny_talwar — Tue, 22 Aug 2017 18:33:49 GMT

How do you create this in the script?

vIsPreviousPeriode

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 19:03:23 GMT

The varibale is declared in the Qlik expression -variables (User interface) not in the Load editor

The variable «vIsPreviousPeriode» is delared like that :

$(vIsCurrentMonthPeriode)&'-'&Right($(vIsPreviousYear),2)

vIsPreviousPeriode will store values like these : JUN-17 ; JUL-17 ; REG-16;...

Re: Issue with variable in set expression - Qlik sense

sunny_talwar — Tue, 22 Aug 2017 19:27:03 GMT

Try this

=Sum({$<Myfield = {"$(=vIsPreviousPeriode)"}>} Mymeasure)

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 20:08:30 GMT

I tried this syntax (=Sum({$<Myfield = {"$(=vIsPreviousPeriode)"}>} Mymeasure)) , before posting my issue !

It doesn't work !

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Tue, 22 Aug 2017 20:16:02 GMT

Re: Issue with variable in set expression - Qlik sense

silvacarlos — Tue, 22 Aug 2017 20:16:03 GMT

I don't know if you can set a variable with other 2 variables inside, I'll search information about that

Re: Issue with variable in set expression - Qlik sense

sunny_talwar — Wed, 23 Aug 2017 11:19:05 GMT

How about this?

=Sum({$<Myfield = {"$(=$(vIsPreviousPeriode))"}>} Mymeasure)

Re: Issue with variable in set expression - Qlik sense

QSMACHBI — Wed, 23 Aug 2017 11:47:47 GMT

It works fine with the last syntax.

Thank you very much

Re: Issue with variable in set expression - Qlik sense

sunny_talwar — Wed, 23 Aug 2017 11:50:07 GMT

Awesome!!! Please close the thread by marking correct and helpful responses.Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny