topic Re: Autogenerate a number in a variable in QlikView

Autogenerate a number in a variable

helen_pip — Sun, 15 May 2016 14:35:43 GMT

Hello,

My load script contains details about the end user, and splits the user into 2 groups dependant on whether they are allowed access to identifiable information or not

I then apply the following variable to all fields which contain identifiable information:

='Content Hidden' & UniqueID

The end user will either see the text "Content Hidden" or the actual identifiable information dependant on the security applied in the load script

Through testing I have noticed that the data in tables is being grouped up and not showing all information when this variable is applied for those who cannot see ID's

I want to know whether I can put another unique identifier on Text I.e. ContentHidden1

ContentHidden2

ContentHidden3

ContentHidden4

Does anyone have any suggestions?

Kind regards

Helen

Re: Autogenerate a number in a variable

kkkumar82 — Sun, 15 May 2016 15:30:13 GMT

Not really understood your requirement but if you are adding data the "ContentHidden" in the load script then you can also add numbers in the same by using RowNO() or RecNO() .

'ContentHidden1' &rowno() &Your field .....

Hope it helps

Re: Autogenerate a number in a variable

Sun, 15 May 2016 16:54:36 GMT

hi Helen,

Use 'contenthidden'&Rowno() this should solve the purpose.

If you have any other requirement , then please elaborate your question.

Re: Autogenerate a number in a variable

MarcoWedel — Sun, 15 May 2016 20:17:23 GMT

Hi,

maybe one solution could be to generate a separate field with the 'hidden' information (yet distinct to use it as dimension):

LOAD FieldContainingIdentifiableInformation,

'Content Hidden' & Autonumber(FieldContainingIdentifiableInformation, 'FieldContainingIdentifiableInformation') as FieldContainingIdentifiableInformationHidden

FROM ...

hope this helps

regards

Marco

Re: Autogenerate a number in a variable

MarcoWedel — Sun, 15 May 2016 20:19:07 GMT

or maybe in the front end:

='Content Hidden' & FieldIndex('FieldContainingIdentifiableInformation', FieldContainingIdentifiableInformation)

hope this helps

regards

Marco