topic Re: Eliminating records in Straight Table in QlikView

Eliminating records in Straight Table

suryaa30 — Wed, 16 Aug 2017 14:08:40 GMT

Hi All,

I have a straight table with a set of dimensions shown. I have count and sum as expressions,

I have records where count is zero but sum having some value in one of the expenses.

I want to remove the records where the count is zero. even though the record has values in one of the expenses.

Count(Claims) -reclamacion

Sum(Hospital Expenses)

Sum(Doctor Expenses)

In below image The fields on left are dimensions and on right are expressions.

Re: Eliminating records in Straight Table

sunny_talwar — Wed, 16 Aug 2017 14:10:28 GMT

Change these two expressions

Sum(Hospital Expenses)

Sum(Doctor Expenses)

If(Count(Claims) > 0, Sum(Hospital Expenses))

If(Count(Claims) > 0, Sum(Doctor Expenses))

Re: Eliminating records in Straight Table

suryaa30 — Wed, 16 Aug 2017 14:46:41 GMT

Hi Sunny that partially resolves. I forgot to mention the scenario.

--Each record can have a payment type say A or B or C

Now in the straight table I mentioned above the expenses are nothing but Sum(A) or Sum(B) or Sum(C)

In the list box if payment type is selected as 'A'

now that I have implanted what you mentioned above. In the show total I have given sum of rows. But even though all record values are 0 for Sum(B) the total shows total value and that is strange.

Re: Eliminating records in Straight Table

sunny_talwar — Wed, 16 Aug 2017 14:55:55 GMT

Sorry what is A, B, & C? Not sure I understand? Would you be able to post a sample?

Re: Eliminating records in Straight Table

suryaa30 — Wed, 16 Aug 2017 15:07:09 GMT

I have attached a sample document.

Now here when I select a particular payment type, I need to see zero in other payment expenses.

Re: Eliminating records in Straight Table

sunny_talwar — Wed, 16 Aug 2017 15:44:41 GMT

So you want the expressions (Reclamacion Count, Siniestro Count, Doctor Expense, Average Doctor Expense, Reembolso Expense, Average Reembolso Expense) to hide when you select Hospital?

Re: Eliminating records in Straight Table

suryaa30 — Wed, 16 Aug 2017 15:50:29 GMT

Reclamacion Count, Siniestro Count,will always remain no matter what the selection is.

Hiding of expense is what I have currently implemented.

But I am trying to retain the all Expense fields but show '0' for those expenses when not selected.

here selection is about Payment type list box and not Hospital.

For example:

If reembelso is selected in payment type.

I want the other expense field to show 0.

Re: Eliminating records in Straight Table

sunny_talwar — Wed, 16 Aug 2017 15:59:00 GMT

Check the attached

Re: Eliminating records in Straight Table

suryaa30 — Wed, 16 Aug 2017 16:11:30 GMT

Hi Sunny,

Thanks Much. Looks ok.

What has been changed and what is the significance?

Re: Eliminating records in Straight Table

sunny_talwar — Wed, 16 Aug 2017 16:15:10 GMT

Added an asterisk within your set analysis within the variables.... read about it here

Implicit Set Operators