Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
suvechha_b
Contributor III

How to make it work in the table view report

How to get the "Is Potential Sales " as filter in my qlikview Model.

I tried to put it but it is not working if I select YES.

The Table is not giving values who have "Is Potential Sales" YES.

Requirement :

I want to all the value when anything is not selected.

if YES then only the YES value

and if NO all the NO Values

Sample Model attached.

Capture.PNG

8 Replies
Not applicable

Re: How to make it work in the table view report

What is your exact requirement ?

Do u want to show all values in the Table box even though you selected only one value "Yes".

suvechha_b
Contributor III

Re: How to make it work in the table view report

I want to all the value when anything is not selected.

if YES then only the YES value

and if NO all the NO Values

miguelbraga
Valued Contributor III

Re: How to make it work in the table view report

I've analyzed your qvw and found that you have no connection between this expression

Is Potential Sales expression:

if(t_distributor='ACW',if(sum(qty_available)<sum([OutStanding Qty]),'NO','YES'),if(t_distributor='UPD' ,if(sum(qty_available)<sum([upd_outstanding_order_qty]),'NO','YES'),if(sum(qty_available)<sum([outstanding_order_qty]),'NO','YES')))

And the field Selection witch is on your Listbox. One thing you can do is create a field with the expression as your Selection_Optimized and use it in the field of your already created Listbox. You can do it like this:

if(t_distributor='ACW',if(sum(qty_available)<sum([OutStanding Qty]),'NO','YES'),if(t_distributor='UPD' ,if(sum(qty_available)<sum([upd_outstanding_order_qty]),'NO','YES'),if(sum(qty_available)<sum([outstanding_order_qty]),'NO','YES'))) as Selection_Optimized


This works if it this new field is on a table that have all these fields!

suvechha_b
Contributor III

Re: How to make it work in the table view report

Can You please do it in the sample model.

Highlighted
Partner
Partner

Re: How to make it work in the table view report

Hello,

I see that you are using a lot of if statements for your expressions. In order to obtain the desired functionality, your expressions have to take into consideration also the values of "Selection" (IsPossibleSales) field. ALL expressions in that table Order, Outstanding Qty, Net Stock. That way when you select "No" in your listbox you get zero values for all expressions for a "Yes" line and QlikView will hide that line.

You might try to use if statements for this, but I suggest you better switch to set analysis.

Kind regards,

Ionut

suvechha_b
Contributor III

Re: How to make it work in the table view report

Hi Ionut,

Please help me to implement in any one of my expression then I will do the rest.

How to implement the set analysis.

Please suggest

Thanks,

Suvechha

suvechha_b
Contributor III

Re: How to make it work in the table view report

Hi Braga,

Please implement the expression in my sample.

As I am unable to implement it.

Thanks,

Suvechha.

Partner
Partner

Re: How to make it work in the table view report

Hi Suvechha,

You have NO link between your values and your "Selection" field, as Braga Miguel also noticed.

So I used a variable to know when to calculate NO lines, YES lines and all lines, depending on your selections in that field. The input box is there only for you to know I added it to your app - you can delete it from interface.

Please see attached my solution to your issue. Is this what you are looking for?

Kind regards,

Ionut