Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is your exact requirement ?
Do u want to show all values in the Table box even though you selected only one value "Yes".
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
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!
Can You please do it in the sample model.
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
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
Hi Braga,
Please implement the expression in my sample.
As I am unable to implement it.
Thanks,
Suvechha.
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