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: 
saumyashah90
Specialist
Specialist

Set analysis help

Hi I have a Straight Table chart in my  UI with some filters on my side

i have   month,year,Sub_Dept , Dept,Team and FA

In chart i m showing expression

Sum( {<CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE

No i have three filters,

1)Dept

2)Sub Dept

3)FA

i want these expression to get change when FA is selected but not when dept and Sub Dept is selected.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

Sum( {<Dept, Sub_Dept, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE )

View solution in original post

2 Replies
tresesco
MVP
MVP

May be like:

Sum( {<Dept, Sub_Dept, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE )

Anonymous
Not applicable

Try this just modifying ur expression:

Sum( {<Dept=, Sub Dept=, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE

Hope this will help!!