Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below will only recode core Brand :-
pick(1+match(if(len(trim(@282:298)),@282:298,subfield(@207:240,' ',1))
,'HAKKO','BECKHOFF','MITSUBISHI','MITSUBISH' ,'GE FANUC','GE','PROJECT','')
,'OTHER','HAKKO','BECKHOFF','MITSUBISHI','MITSUBISHI','GE FANUC','GE FANUC','PROJECT','') as [BRAND_MISC],
Below will recode all Brand :-
pick(1+match(if(len(trim(@282:298)),@282:298,subfield(@207:240,' ',1))
,'HAKKO','BECKHOFF','MITSUBISHI','MITSUBISH' ,'GE FANUC','GE','HENGSTLER','SCHAFFNER','REDLION' ,'HMS','PROJECT','SECOMEA','KEB' ,'')
,'OTHER','HAKKO','BECKHOFF','MITSUBISHI','MITSUBISHI','GE FANUC','GE FANUC','HENGSTLER','SCHAFFNER','REDLION','HMS','PROJECT','SECOMEA','KEB' ,'') as [BRAND_],
Notice the diff is :-
BRAND_MISC hv only 7 Brand
BRAND_ hv more then 7 Brand.
So there are 2 type of Brand field.
Reasons for above 2 field name of Brand :-
when i plot sales by Brand using Table it is okay , i can view all brand sales. But for chart , sales by Brand ( Stack chart ) it is not possible to use BRAND_ , Because it will not able to view all sales , since too many small brand sales.
when i need to create list box for user filter individual brand , it is easy to create list box with BRAND_MISC since it have only 7 brand.
i need to create a list box using BRAND_ , why i am not able to use for BRAND_MISC ?
A bit confuse right ? i feel it also ... now i create a qv doc to explain.
Paul
Paul
Perhaps an alternatively is to restrict the number of dimensions-values to 7 and show all further values as "Other".
Within your listbox you could use a dimension-group to switch between the brand-fields.
- Marcus
Hi Marcus
See my QV doc , mine issue is not because of Other.
Sorry Paul, but the app is too complex. There are too many possibilities for a quick help from the community. I wouldn't want to maintain or further develop the app.
I suggest to simplify these app through more using from native qv-usability and/or to split in several apps.
- Marcus
hI mARCUS
no issue. thank you very much.
Have you considered using a crosstable?
Hi sir
Sure I like use cross tab . Any link for me to start with case ?
Paul
Sent from Samsung Mobile
The crosstable explanation in the Reference Manual is pretty straightforward and easy to understand
Ok thank you very much.
Sent from Samsung Mobile