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

How to make it work in the table view report

suvechha_b — Thu, 15 Oct 2015 13:11:08 GMT

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.

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

Thu, 15 Oct 2015 13:14:38 GMT

What is your exact requirement ?

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

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

suvechha_b — Thu, 15 Oct 2015 13:22:38 GMT

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

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

miguelbraga — Thu, 15 Oct 2015 13:41:38 GMT

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:

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

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

suvechha_b — Thu, 15 Oct 2015 13:45:32 GMT

Can You please do it in the sample model.

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

ionut_toader — Thu, 15 Oct 2015 13:57:44 GMT

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

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

suvechha_b — Thu, 15 Oct 2015 14:03:16 GMT

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

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

suvechha_b — Thu, 15 Oct 2015 14:04:27 GMT

Hi Braga,

Please implement the expression in my sample.

As I am unable to implement it.

Thanks,

Suvechha.

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

ionut_toader — Thu, 15 Oct 2015 19:05:48 GMT

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