Re: Add grouped fields to the table

dia2021 · ‎2021-12-10

Hi,

I have created a new grouped field with a wild function in a column at the script level. This works fine when I use it as a separate field.

If(wildmatch(Category, 'Table', 'Chair', 'Bed'), 'Home_Category') as Cat_group

My problem is how can I add it back to the table and use this field in the where clause in the script.

My main script is

Lib connect to '.....';

Load date ,

Status ,

Category,

If(wildmatch(Category, 'Table', 'Chair', 'Bed'), 'Home_Category') as Cat_group,

Sales,

[SalesData]:

Select date,

Status,

Category,

Sales,

From …….

Where Category = ‘ABC’ or Category = ‘XYZ’ or Category = 'Home_Category';

Thanks in advance. Any suggestions are appreciated!

anat · ‎2021-12-11

u can use resident of above table and filter the data using where condition

dia2021 · ‎2021-12-12

@anat Thanks for the reply! Would you mind elaborating on the resident load? How and where can I add it to the above load? The data is connected to the database table as mentioned above. It would be helpful to understand for future tasks as well, as I'm new to the qliksense.

Much appreciated!

dia2021 · ‎2021-12-13

Hi, Could you please explain how to do the resident load based on the above script? Thank you!

MarcoWedel · ‎2021-12-13

You could also try with

Where Wildmatch(Category, 'Table', 'Chair', 'Bed', 'ABC', 'XYZ');

hope this helps

Marco

Add grouped fields to the table

Advanced Authoring

Client Managed

General Question

SaaS