how to group the data and set as a button

[wendytham]

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.

[Anil_Babu_Samineni · Accepted solution]

Check if that helps?

[wendytham]

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.

[Anil_Babu_Samineni]

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');