topic Re: Selecting value based on multiple conditions in QlikView

Selecting value based on multiple conditions

VilmaB — Sat, 16 Nov 2024 20:39:22 GMT

Hello experts,

I have a data table:

Could hepl me tyo find out, what should be an expresion to select Saifi value, for each ID, where duration is more then 0,05 and has max customer number. Dimension is Time.

The result table should be like this:

Thanks, Vilma

Re: Selecting value based on multiple conditions

sunny_talwar — Mon, 17 Jun 2019 12:12:49 GMT

This seems more easily doable if ID was the dimension and Time was one of the expression... would you be able to provide the Excel file with the data so that we can load that instead of hand typing everything to create a sample.

Re: Selecting value based on multiple conditions

VilmaB — Mon, 17 Jun 2019 12:36:52 GMT

There is my file.

Ok, lets try if ID is dimension.

Re: Selecting value based on multiple conditions

sunny_talwar — Mon, 17 Jun 2019 12:38:33 GMT

Not looking for an image file, but an Excel file

Re: Selecting value based on multiple conditions

VilmaB — Mon, 17 Jun 2019 12:40:33 GMT

🙂

Re: Selecting value based on multiple conditions

ramasaisaksoft — Mon, 17 Jun 2019 14:12:27 GMT

Hello Vilma,

As per the expected output

Create a Pivot /Straight table

Dimensions are: Time,ID,Duration,Customer Number

Expression =Aggr(Min(Saifi),ID)

check this once & correct me if i understood wrongly

Re: Selecting value based on multiple conditions

VilmaB — Mon, 17 Jun 2019 15:52:40 GMT

Hello Ramasaisaksoft,

as you suggestion works fine, but I still need to do not include Duration dimension where it is less then 0.05.

Time dimension is created as calendar group (time, week, month...), so if I choose the month, it shows all rows separately, but I need the SAIFI sum for this time period.

could you help me 🙂

Re: Selecting value based on multiple conditions

sunny_talwar — Mon, 17 Jun 2019 16:02:20 GMT

Check attached

Re: Selecting value based on multiple conditions

VilmaB — Tue, 18 Jun 2019 09:26:39 GMT

Thank you! It works.