topic Re: Set analysis help in QlikView

Set analysis help

saumyashah90 — Fri, 06 Nov 2015 07:29:39 GMT

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.

Re: Set analysis help

tresB — Fri, 06 Nov 2015 07:33:16 GMT

May be like:

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

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

Re: Set analysis help

Anonymous — Fri, 06 Nov 2015 07:33:24 GMT

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!!