Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.