
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Custom Dimension Using Qliksense
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any suggestions @Vegar , @kaushiknsolanki

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It does'nt work shows '-' as value in dimension column of the table

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Attached sample doc for reference

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
