topic Re: Edit data from front end in QlikView

Edit data from front end

anuradhaa — Thu, 13 Feb 2014 17:41:26 GMT

Hi,

In my data based i have customer column. currently i have 3 customers.

Then i used list box to view each customer data separately.

For a demo i need to use this document but i don't need to show the customer names. So it is difficult(time consiuming thing)

edit the customer names in script or data base.

So is there a way to replace customer names in front end of a list box.

Thanks

Thu, 13 Feb 2014 17:45:28 GMT

You can scramble Customer field in your desktop version.

Go to Document Properties > Scrambling > Select Customer > then scramble

MK_QSL — Thu, 13 Feb 2014 17:46:07 GMT

Go to Settings

Document Properties

Scrambling

Select Customer Name

Scramble

maxgro — Thu, 13 Feb 2014 17:46:22 GMT

use an expression in listbox

=pick(match(CustomerColumn, 'A1', 'B1', 'C1'), 'aaa', 'bbb', 'ccc')

but the other chart with same CustomerColumn?

Thu, 13 Feb 2014 19:39:08 GMT

Massimo and Ajay... Learnt something new today

Thu, 13 Feb 2014 19:42:47 GMT

Might not be a helpful trip since its on script side...

if you have very few values in list.... you can use mapping table and apply map to replace customer names with custom names