topic Re: Multi selections using set analysis in QlikView

Multi selections using set analysis

engr_farhanqadr — Fri, 08 Mar 2019 11:12:49 GMT

Hi folks,

I am using the below formula , it is working fine when I select Year and then one value for Quarter like q1 or q2 but I want to multi select in quarter field for 6 months or 9 months what to change in below formula. sum({< [Master_INTIMATION.YearlyQuarter]={"<$(=GetFieldSelections(YearlyQuarter))"}
,[settle_master.Year]={">=$(=GetFieldSelections(Year))"},[settle_master.YearlyQuarter]={">=$(=GetFieldSelections(YearlyQuarter))"} >} PAID)

Thanks

Re: Multi selections using set analysis

sunny_talwar — Fri, 08 Mar 2019 12:24:24 GMT

May be try this

Sum({<
  [Master_INTIMATION.YearlyQuarter] = {"<$(=MaxString(YearlyQuarter))"},
  [settle_master.Year] ={">=$(=Max(Year))"},
  [settle_master.YearlyQuarter] ={">=$(=MaxString(YearlyQuarter))"}
>} PAID)

Re: Multi selections using set analysis

engr_farhanqadr — Mon, 11 Mar 2019 07:48:01 GMT

Dear sunny,

it is not working for selecting more than one field value in yearlyquarter.

Re: Multi selections using set analysis

sunny_talwar — Mon, 11 Mar 2019 19:19:21 GMT

How do you create [Master_INTIMATION.YearlyQuarter] in the script?

Re: Multi selections using set analysis

engr_farhanqadr — Tue, 12 Mar 2019 05:53:49 GMT

like this

floor(Dual('Q' & ceil(Month(TempDate)/3) & ' ' & Year(TempDate), Year(TempDate)*10+ ceil(Month(TempDate)/3))) AS YearlyQuarter,

the problem is : the set analysis I used is not showing correct result when i select two values in YearlyQuarter for half year(q1 q2 ) , i also tried maxstring but no luck...