Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Disabling the selection on Dimension


Hi,

I have a requirement wherein all the months must get displayed in the chart irrespective of the month selected.I have added month as a dimension in the chart.Please let me know how this could be acheived

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use set analysis in the expression of the chart like:

=Sum({<YourMonthField>}Sales)

View solution in original post

3 Replies
tresesco
MVP
MVP

Use set analysis in the expression of the chart like:

=Sum({<YourMonthField>}Sales)

aveeeeeee7en
Specialist III
Specialist III

Hi

You can use any of the below expressions:

1.  Sum({<Month>}Value)

2. Sum({<Month=>}Value)

3. Sum({1}Value)

Kindly replace Month & Value with your Application Field Names.

Regards

Aviral Nag

jagan
Partner - Champion III
Partner - Champion III

HI,

Just exclude the month values by giving MonthDimensionName= in your set analysis statement

=Sum({<MonthDimensionName=>}MeasureName)


Note: Replace MonthDimensionName and MeasureName with your actual dimension names.


Regards,

Jagan.