Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Try something similar.
Please find the attached.
Regards
ASHFAQ
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
Hi,
In that case use Match function.
attached application will give you a better idea on how to achieve this.
Regards
ASHFAQ
Thanks again for being to hand on this, but i can't see where this would create a new table in script.
sorry
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
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.