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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.