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: 
Not applicable

Filtering the Data

jaganvinay_bangari

Hi Experts,

I'm trying to filter the data by the LOB ID. Please find the attached screen shot.

Thanks in advance.

FlatFiles Members.png

1 Solution

Accepted Solutions
Not applicable
Author

sum({<LOB_ID ={705,706,713}>}DENOMINATOR)

View solution in original post

7 Replies
m_woolf
Master II
Master II

What is your question?

Not applicable
Author

Hi

Trying to filter the data(i.e., sum(DENOMINATOR) ) by Lob Id

Can you please refer in the screen shot and qvw.file so that you will get an clear idea.

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

I'm not quite sure what's the question here. Based on your screen shot, LOB 709 doesn't exist in May 2016.

On the other hand, the attached QVW file only contains data for April and June, so it's hard to recreate the same picture.

You may need to explain your problem in more detail - what exactly is wrong?

Not applicable
Author

sorry for the confusion. please exclude LOB 709. The screen shot is just the sample data. You dont have to get the exact values, we have to filter the data by the LOB ID condition.

m_woolf
Master II
Master II

I still don't understand what your question is. If you need to filter by LOB ID, what's stopping you?

Not applicable
Author

Sorry for the incorrect question. i need to create a expression for that condition.

Not applicable
Author

sum({<LOB_ID ={705,706,713}>}DENOMINATOR)