Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
qliksase
New 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

Re: Question concerning "filtering" values in tables in Qlikview

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
New Contributor

Re: Question concerning "filtering" values in tables in Qlikview

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

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

Re: Question concerning "filtering" values in tables in Qlikview

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

qliksase
New Contributor

Re: Question concerning "filtering" values in tables in Qlikview

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

Re: Question concerning "filtering" values in tables in Qlikview

Sounds good

qliksase
New Contributor

Re: Question concerning "filtering" values in tables in Qlikview

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

Re: Question concerning "filtering" values in tables in Qlikview

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