Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
There is a listbox with 'Breakage Reasons'.
When a 'Breakage reason' is selected, I would like to see the data filtered with the selected 'Breakage'
and also the data without breakage, that is breakage reason is empty or '-'.
Please suggest how can i acheive it.
PFA the sample qvw file
Thanks,
Deepa V
Check this
Hi
:
It may be for two reasons.
the first, the fields have no information.
second, they have more than one value '-'
I saw your dashboard and say that is the first reason.
regards
Erik Mendieta wrote:
Hi
:
It may be for two reasons.
the first, the fields have no information.
second, they have more than one value '-'
I saw your dashboard and say that is the first reason.
regards
Hello Erik,
Thanks for the reply.
I will not get the breakage code '-' in Breakage reasons.
So I loaded by concatinating '-' in Breakage Reasons list box.
But, I have the below challenges:
1 .when I select '-' in list box, data is not filtering.
2. I need to see the data with breakage reason '-' + selected 'breakage reason' in result.
Pls find attahced the revised qvw.
Please help me.
In my opinion you have a problem in the script and the data are non good relationship
See the tables
Hi Deepa
what if you Joined the "LMTB_BREAKAGE_REASON_EOLT " Table to the "LMTB_Product_EOLT"
using entity Code ? instead of Joining on the "BREAKAGE REASON"
Check this
Hello Enrique Colomer,
Thanks for the reply,
I am loading data from the attached excel.
Please suggest, is there any issue with datamodel or while loading other tables .
Thanks,
Deepa V
Hello Anbu cheliyan,
Yes, in the document, when ever any breakage code is selected in the table I am seeing '-' as selected.
But now I am seeing 2 values with '-', on clear selection.
whenever I select any breakage code EX: 'HC_FALL'
I am seeing as below:
count should be 1000 for breakageCode '-'
Please help me.
Thanks,
Deepa V
Check this
Hi Anbu Chelian,
Thanks a lot for this, It is ok now.
I am trying to get something like below:
BREAKAGE_REASON | othercnt | If(nullcount<>0,nullcount,othercnt) | Percentage Rejected | |
1009 | ||||
HC_FALL | 1009 | 2 | 2/1009 | 0.19 % |
SG_BK | 1009 | 1 | 1/1009 | 0.10% |
SG_ENG | 1009 | 1 | 1/1009 | 0.10% |
SG_PR | 1009 | 3 | 3/1009 | 0.29% |
SG_PWR | 1009 | 1 | 1/1009 | 0.10% |
SG_WXS | 1009 | 1 | 1/1009 | 0.10% |
- | 1009 | 9 | 9/1009 | 0.89% |
Kindly help me with this
Thanks,
Deepa V