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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Including only specific rows

Good morning

Hope all are well.

I have a loaded table that has the following elements:

Account        Month          Balance

123456          Oct               26000

123456          Nov              28000

123456          Dec              28500

123456          Jan               25000 

122244          Oct               27500

123321          Jan               10000

123321          Oct                12000

I have a straight table and I only want to pull rows where an account has a row in each month (Oct,Nov,Dec,Jan) and has a balance greater than 25000 in each month.

In the example above, these would be the only rows pulled:

123456          Oct               26000

123456          Nov              28000

123456          Dec              28500

123456          Jan               25000

Thank you

12 Replies
Not applicable
Author

Thank you that helped except the text has been converted to exponential text format.

How can I convert so I show all 18 characters.

Thanks again

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps using the Dual function. Dual(Text(MyNumber), MyNumber) as MyNumber


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you but still showing as exponential text