topic Re: Add grouped fields to the table in App Development

Add grouped fields to the table

dia2021 — Fri, 10 Dec 2021 19:03:54 GMT

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!

Re: Add grouped fields to the table

anat — Sat, 11 Dec 2021 07:47:57 GMT

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

Re: Add grouped fields to the table

dia2021 — Mon, 13 Dec 2021 03:14:01 GMT

@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!

Re: Add grouped fields to the table

dia2021 — Mon, 13 Dec 2021 15:37:06 GMT

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

Re: Add grouped fields to the table

MarcoWedel — Mon, 13 Dec 2021 19:32:00 GMT

You could also try with

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

hope this helps

Marco