Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ksomosera10
Creator II
Creator II

If-Sum then Count Distinct

Hi!

Can you help me out on my problem?

I have this table and text box. Here's what I need. I want to show in my text box the distinct count of people having a specified criteria and condition.

Just to give you an idea, here's a sample data on my table:

|      Name    |  Power        |  Element |    HP    |

|    Batman  |  Batpower  |      Dark  | 1000    |

| Spiderman |    Web        |  Nature  |  900    |

| Aquaman  |Trident Strike|    Water  |  2000  |

On my text box I want to show this kind of expression:

If Element == 'Nature' and HP <= 1000 Then Count Distinct Name


I hope this helps you understand my problems...

Thanks!

32 Replies
sunny_talwar

But if Resource Name have more than one Programming, then the combined Sum(nAlloc) could still be greater than 99 for instance....

Resource Name     Programming     nAlloc

ABC                         P1                         80

ABC                         P2                         20

Would you include it or exclude it? I guess depends on the user requirement and data. But our expressions are def. not the same

Kushal_Chawda

Bas bhai..tune bol diya to baat khatam.. expression alag he

sunny_talwar

Thank you yaar