Custom Dimension Using Qliksense

[anushree1]

Hi,

I am trying to create custom Dimensions using Value List , the expression i am trying is as below:

valuelist(month(min({<Flag={'Act'}>}YearMonth))&'-'&month(AddMonths(min({<Flag={'Act'}>}YearMonth),2)),
month(AddMonths(min({<Flag={'Act'}>}YearMonth),3))&'-'&month(AddMonths(min({<Flag={'Act'}>}YearMonth),5)))

I have tried static Dimension values by hardcoding but using functions I am trying for the First time not sure if this approach works, in case it does'nt would like to know if there is anyother alternative 

[anushree1]

Any suggestions @Vegar , @kaushiknsolanki 

[kaushiknsolanki]

Try this.

valuelist('$(=month(min({<Flag={'Act'}>}YearMonth)))&'-'&$(=month(AddMonths(min({<Flag={'Act'}>}YearMonth),2))),
$(=month(AddMonths(min({<Flag={'Act'}>}YearMonth),3)))&'-'&$(=month(AddMonths(min({<Flag={'Act'}>}YearMonth),5)))')

Regards,

Kaushik Solanki

[anushree1]

It does'nt work shows '-' as value in dimension column of the table

[anushree1]

Attached sample doc for reference

[miskinmaz · Accepted solution]

You can't use the set analysis  in custom dimensions or calculated dimensions.

One way is try to create a variable where you write the set expression with = sign and then use this variable in value list expression