Disguise Data With Formats

[#1]

Good morning from the rainy isle of the UK.

Again, i call upon the usefull knowledge and amazing resource of all my fellow QlikView users.

Within my data model i have a few tables where i would like to apply formats to make the dashboard front end a bit more user friendly.

I have certain text strings in a the dashboard which look quite messy, i would like to group e.g:

Product	Group
Bike	BIKE
Bicycle	BIKE
Push Bike	BIKE
Road Bike	BIKE
Sky T-Shirt	TOPS
Sky Jersey	TOPS
Pinn Jersey	TOPS
Gel Shorts	SHORTS
Shorts	SHORTS
Padded Shorts	SHORTS
Long Compression Shrt	SHORTS
Hex XL Short	SHORTS

I'm in a position where i know the strings to expect,  but i dont know how to build a new table from the feild to use in the dashboad.

This would help the front end report user make easier selections.

I know it would make a lot more sense to change this at a raw level, but the way our qlikview server model works, there is a long turn around time, as i know what data to expect this would help me a lot.

Thank you

[ashfaq_haseeb]

Hi,

Try something similar.

Please find the attached.

Regards

ASHFAQ

[#3]

ASHFAQ,

thanks for the speedy response...

I do not have the GROUP field, this is something i actually need to define the rules for in the script to build a new table eg:

IF TABLE_A.PRODUCT = 'Long Compression Shrt' Then NEW_TABLE.GROUP = 'SHORTS'

i know thats not the syntax btw

so i need to know how to create an new table based on the data from PRODUCT and create a new table with current PRODUCT field and new field called GROUP

[ashfaq_haseeb]

Hi,

In that case use Match function.

attached application will give you a better idea on how to achieve this.

Regards

ASHFAQ

[#5]

Thanks again for being to hand on this, but i can't see where this would create a new table in script.

sorry

[mdmukramali · Accepted solution]

Dear ,

this is how you can create a new table.

my using match function in the script we can create Group fields.

Kindly find the attached file.

i hope it will help you.

Thanks,

Mukram

[#7]

Thats brilliant, as my table doesnt have a huge amount of combinations so a small nested match like that will work a treat, thank you.