Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have model and sales data.
I need to group model data into 2 series.
Eg. AB-12TH100A = TH100 series
AB-13TH100B = TH100 series
AB-12T300A = T300 series
AB-12T300B = T300 series
how to create a "series" variable in QV and also create a button for each series?
Thank you.
Check if that helps?
Check if that helps?
Hi,
How if i have DZ-12TH100A, TU-12TH100B, etc, but i do not want to include them as i want the model start with
AB-*TH100* only?
And, add one more series is included both TH100 & T300 series, how to do this?
Thanks.
You can restrict using below?
LOAD Model,
Sales,
If(Index(Model,'TH100'), 'TH100 Series', If(Index(Model,'T300'),'T300 Series')) as Model_Series
FROM
[..\..\..\Downloads\sales.xlsx]
(ooxml, embedded labels, table is Sheet1) Where Match(SubField(Model,'-',1),'AB');