topic Set Analysis with Inputbox or prompt in QlikView

Set Analysis with Inputbox or prompt

Mon, 30 Aug 2010 10:05:07 GMT

Hi ,

I have a requirement where as we want to exclude certain ticketids from the SLA Calculation. It should work in this way. It should prompt for the Ticketid that should be excluded. It can be multiple Ticketids.

Is it possible to do with the SET Modifiers.

Normally the formula will be (sum(Tickets within SLA)/Sum(Closed Tickets))*100.

Regards,XXX

Set Analysis with Inputbox or prompt

Miguel_Angel_Baeyens — Mon, 30 Aug 2010 10:50:37 GMT

Hello,

As inputboxes work with variables, you may use something like

(Sum({< TicketdID = {'$(vVariable)'} >} Field) / Sum(Closed Tickets))*100

Is that what you are looking for?

Set Analysis with Inputbox or prompt

Mon, 30 Aug 2010 10:58:58 GMT

Hi Miguel,

Thanks for your response. Yes it was i am looking but small change in that whatever ticketid i am passing through the Input boxes should be excluded and remaining tckets should be counted.

Regards,XXX

Set Analysis with Inputbox or prompt

Miguel_Angel_Baeyens — Mon, 30 Aug 2010 11:06:57 GMT

Hi,

Not knowing your data model, could it be something like

(Sum({< TicketdID -= {'$(vVariable)'} >} Field) / Sum(Closed Tickets))*100

Note the minus sign before the equal, the -= operator meaning "all but the following"

Set Analysis with Inputbox or prompt

Mon, 30 Aug 2010 12:36:52 GMT

Hi Miguel,

The Query i am using Currently is

SUM(IF((CTA=0 and RPS<=100 AND SUS>3),1,0))/SUM(IF((CTA=0 and RPS<=100 AND SUS>3),1,0))

and i am trying to modify based on ur suggestion

I have few queries as

Can the variables can have multiple values (Comma seperated values)?

Regards,XXX

Set Analysis with Inputbox or prompt

Miguel_Angel_Baeyens — Mon, 30 Aug 2010 12:52:59 GMT


XXX wrote:Can the variables can have multiple values (Comma seperated values)?

Yes, you can create a variable in script or using CTRL + ALT + V such in

SET vVariable = 1, 2, 3, 4;

If there are no constraints set in your inputbox, you can enter

1, 2, 3, 4

and so it will be stored in the variable.

When you use it in set analysis, it will work in my example above.

Your expression might look like

Sum({< CTA = {0}, RPS = {'<=100'}, SUS = {'>3'} >} 1) / Sum({< CTA = {0}, RPS = {'<=100'}, SUS = {'>3'} >} 1)

written in set analysis form, although I'm guessing you are trying to count (sum 1) rather than sum.