Pick Match

vvvvvvizard — Wed, 25 Nov 2020 16:16:04 GMT

Why this query always return the value of the 1st expression

Pick(Match(vDateView=1 and vMeasure=2 and vIFRS = 1 and v_Wastage=2,
vDateView=1 and vMeasure=2 and v_Wastage=1 and vIFRS = 2,
vDateView=1 and vMeasure=2 and v_Wastage=2 and vIFRS = 2 ,

vDateView=2 and vMeasure=2 and vIFRS = 1 and v_Wastage=2,
vDateView=2 and vMeasure=2 and v_Wastage=1 and vIFRS = 2,
vDateView=2 and vMeasure=2 and v_Wastage=2 and vIFRS = 2 ,

vDateView=1 and vMeasure=10 and vIFRS = 1 and v_Wastage=2,
vDateView=1 and vMeasure=10 and v_Wastage=1 and vIFRS = 2,
vDateView=1 and vMeasure=10 and vIFRS = 2 and v_Wastage=2,

vDateView=2 and vMeasure=10 and vIFRS = 1 and v_Wastage=2,
vDateView=2 and vMeasure=10 and v_Wastage=1 and vIFRS = 2,
vDateView=2 and vMeasure=10 and v_Wastage=2 and vIFRS = 2

),
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))}, Acct_Type -= {'IFRS - Reversal'} >} CPV * Value_Used),
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used) ,
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))} >} CPV * Value_Used) ,

Sum({<FIN_YR_NO={$(v_Max_Year)},Acct_Type -= {'IFRS - Reversal'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)} >} CPV * Value_Used) ,

Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))}, Acct_Type -= {'IFRS - Reversal'} >} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO>{<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))}, Acct_Type -= {'IFRS - Reversal'} >} CPV * Value_Used),
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO>{<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used) ,
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))} >} CPV * Value_Used) /Sum(TOTAL <YR_MTH_NO> {<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))} >} CPV * Value_Used) ,

Sum({<FIN_YR_NO={$(v_Max_Year)},Acct_Type -= {'IFRS - Reversal'}>} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO> {<FIN_YR_NO={$(v_Max_Year)},Acct_Type -= {'IFRS - Reversal'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO> {<FIN_YR_NO={$(v_Max_Year)},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)} >} CPV * Value_Used) /Sum(TOTAL <YR_MTH_NO> {<FIN_YR_NO={$(v_Max_Year)} >} CPV * Value_Used)

)

Re: Pick Match

venkat1 — Tue, 15 Oct 2019 12:54:00 GMT

because you are writing in an order

Re: Pick Match

vvvvvvizard — Tue, 15 Oct 2019 14:22:34 GMT

I just realized there is no field name at the beginning of the pick match

Re: Pick Match

vvvvvvizard — Wed, 16 Oct 2019 11:50:06 GMT

So can one use Pick Match with variables only ?

topic Re: Pick Match in QlikView

Pick Match

Re: Pick Match

Re: Pick Match

Re: Pick Match