topic Re: Disguise Data With Formats in QlikView

Disguise Data With Formats

Thu, 22 May 2014 08:57:51 GMT

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

Re: Disguise Data With Formats

ashfaq_haseeb — Thu, 22 May 2014 09:39:59 GMT

Hi,

Try something similar.

Please find the attached.

Regards

ASHFAQ

Re: Disguise Data With Formats

Thu, 22 May 2014 09:54:51 GMT

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

Re: Re: Disguise Data With Formats

ashfaq_haseeb — Thu, 22 May 2014 10:06:54 GMT

Hi,

In that case use Match function.

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

Regards

ASHFAQ

Re: Disguise Data With Formats

Thu, 22 May 2014 10:34:09 GMT

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

sorry

Re: Re: Disguise Data With Formats

mdmukramali — Thu, 22 May 2014 13:54:37 GMT

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

Re: Disguise Data With Formats

Fri, 23 May 2014 09:21:20 GMT

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.