Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Collating records when Yes is selected

Hi....I am currently using Qlikview to compare our outstanding purchase order quantity against the maximum quantity set for the Inventory. I have created a chart that has identified this with a yes or no but what I am wanting is to be able to select only the records that state "Yes". I am hoping someone can help.

Thanks

5 Replies
reddy-s
Master II
Master II

Hi Chris,

Try this:

sum({$< Field = {"Yes"} >}Quantity)/ Sum(Max({$< field = {"Yes"} >}Quantity))

here "field" is the col which has values "Yes"/"No"

If this does not solve your issue, its better to attach a sample qvf or a qvw .

Thanks,

Sangram Reddy.

Not applicable
Author

Hi Sangram,

Thanks for your help. I am afraid I am very much a novice with Qlikview and I  am only just learning to use it. I have shared the qvw file with you. Can you please have a look at it for me as I have tried the formula with no success.

Regards,

Chris

reddy-s
Master II
Master II

Hi Chris,

I am sorry, I cannot see your attached file. Can you attach it once again?

Thanks,

Sangram Reddy.

Not applicable
Author

Hi Sangram,

The file I uploaded was rejected because I did not have a description about the file. I have added a description and reloaded.

Thanks,

Chris

reddy-s
Master II
Master II

Hi Chris,

I am sorry to say that I still can't find your file attached. hacked opening the thread with multiple browsers too.

Thanks,

Sangram Reddy.