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: 
qliksase
Contributor
Contributor

Question concerning "filtering" values in tables in Qlikview

Hello together,

I am quite sure my question is easy for a lot of you guys:

I want to analyse orders based on their status.

So open orders, should only show Orders, that are in the status "Released" bot don't have a second entry with

the Status "Technically completed". (Table 2 in the Screenshot)

Closed orders, should only show orders with the Status "Technically completed". (Table 3 in the screenshot)

filtering.jpg

I have different ways in mind, but I am quite sure there is an easier way than my thinking.

Please help me out. Thank you in advance

Sascha

7 Replies
sunny_talwar

May be this for your Only Released orders

Dimensions

OrderNo

Date

StatusDescr.

MaterialNo

MaterialDescription

Expression

Count({<ID = e({<StatusDescr = {'Technically completed'}>}), StatusDescr = {'Released'}>} ID)

For the other chart

Dimensions

OrderNo

Date

StatusDescr.

MaterialNo

MaterialDescription

Expression

Count({<ID = e({<StatusDescr = {'Released'}>}), StatusDescr = {'Technically completed'}>} ID)

qliksase
Contributor
Contributor
Author

Sorry, that doesn't work. Placing the expression brings me an empty table.

But, I think we are close.. Any further ideas ?

sunny_talwar

Would you be able to share a sample to test this out

qliksase
Contributor
Contributor
Author

Yes, but I already left the office. I will upload it tomorrow in the morning. Thank you so much for your support.

sunny_talwar

Sounds good

qliksase
Contributor
Contributor
Author

Hi Sunny,

attached is the demo file (with dummy data). In the demo file, I used two excel spreadsheets,

in reality the data comes from the ERP system. But I think to get the logic, this demo file is suitable.

Thank you in advance

Sascha

sunny_talwar

I guess I used a non-existent field called ID, it should have been called OrderNo (My bad ). Also, the second expression needs to change... here are the two new expressions

Count({<OrderNo = e({<[StatusDescr.] = {'Technically completed'}>}), [StatusDescr.] = {'Released'}>} OrderNo)

Count({<StatusDescr. = {'Technically completed'}>} OrderNo)

Capture.PNG