topic Re: convert if to set analysis in QlikView

convert if to set analysis

Wed, 26 Oct 2016 21:23:51 GMT

Hi Experts,

Can somenone pls help me writing below code in set analysis?

=count(if((Reported_Out_All.count_id =' ' And

not Isnull(Reported_Out_All.Bill_Type_Details) and

(QuarterName(Reported_Out_All.Reported_Out_Date) = QuarterName(max_Reported_Out_Date_All))),

Reported_Out_All.Reported_Out_case_id) )

Thanks,

Rohini. M

rospigliosi — Thu, 27 Oct 2016 15:27:46 GMT

Hi Rohini,

try this one:

=count({<

Reported_Out_All.count_id ={" "},

Reported_Out_All.Bill_Type_Details={"*"},

QuarterName(Reported_Out_All.Reported_Out_Date) = {"$(=QuarterName(max_Reported_Out_Date_All))"}

Reported_Out_All.Reported_Out_case_id)

Thu, 27 Oct 2016 18:44:25 GMT

Hi Camillo,

Thank you for your reply. But its showing error at

QuarterName(Reported_Out_All.Reported_Out_Date) = {"$(=QuarterName(max_Reported_Out_Date_All))"}

this part of expression. So cant we give dynamic value as set modifier?

Can you pls help fixing this.

Thanks,

Rohini. M