topic Re: Re: removal of hard code in the set expression in QlikView

removal of hard code in the set expression

Thu, 22 Aug 2013 09:53:02 GMT

hi,

Can anyone help me to modify the set expression by removal of hard code.

This expression counts the number of promoters whose CSAT overall score >=3 and the same expression has to be modified by using [ResolvedTicket.CSAT Overall Score] >= CSAT_Promotors_Max and [ResolvedTicket.CSAT Overall Score]<=CSAT_Promotors_Min,

=count({$<[Common Ticket Type]={'INCIDENT'},

[Common Status]={'Resolved','Closed'},

[ResolvedTicket.CSAT Overall Score]={">=3.00"},

ResolvedTicket.InAMSScope={'-1'}>}ResolvedTicket.TicketID)

Am unable to get the solution. please find the attached for your reference.

please help me to modify the expression.

Thanks in advance.

Smitha

Re: removal of hard code in the set expression

stigchel — Thu, 22 Aug 2013 12:54:38 GMT

I'm guessing that this is an example of what you are looking for:

[ResolvedTicket.CSAT Overall Score] >= $(=CSAT_Promotors_Max)

$(= ) --> This is called Dollar-Sign Expansion (look in the help)

Re: Re: removal of hard code in the set expression

Fri, 23 Aug 2013 04:49:15 GMT

hi,

I need an expression to get the value which lies in the range Promters max and Promoters min.

Below is the expresssion which needs to be modified.

[ResolvedTicket.CSAT Overall Score] >= CSAT_Promotors_Max and [ResolvedTicket.CSAT Overall Score]<=CSAT_Promotors_Min,

Please find the attached xls for the reference.

Thanks in advance,

Smitha

Re: Re: removal of hard code in the set expression

Fri, 23 Aug 2013 05:12:28 GMT

hi,

I need an expression to get the value which lies in the range Promters max and Promoters min.

Below is the expresssion which needs to be modified.

[ResolvedTicket.CSAT Overall Score] >= CSAT_Promotors_Max and [ResolvedTicket.CSAT Overall Score]<=CSAT_Promotors_Min,

Please find the attached xls for the reference.

Thanks in advance,

Smitha

Re: removal of hard code in the set expression

MayilVahanan — Fri, 23 Aug 2013 05:42:07 GMT

Try like this

=count({$<[ResolvedTicket.CSAT Overall Score] = {'>=$(=CSAT_Promotors_Max) <= $(=CSAT_Promotors_Min)'},

[Common Status]={'Resolved','Closed'},

[ResolvedTicket.CSAT Overall Score]={">=3.00"},

ResolvedTicket.InAMSScope={'-1'}>}ResolvedTicket.TicketID)

Re: removal of hard code in the set expression

Fri, 23 Aug 2013 07:06:21 GMT

hi,

thank you so much for the solution, it worked fine.

Regards,

Smitha