Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Employee
Employee

What exactly is this doing?

If ($(vDevelopment)=1,$1,Autonumberhash256($1))

What is the $1 doing in this load statement?

Thanks

2 Replies
Highlighted
MVP
MVP

A bigger picture of your script could help understand that. It could be just a field name, it could be an argument passed to a function/sub-routine,...

Highlighted
Employee
Employee

This is actually a variable(vKeyConverter)

The variable is then placed at the front of code that is building a key:

$(vKeyConverter([SNAPSHOT_ID]&
'$(vKeyDellimitter)'& [EMP_DK]&
'$(vKeyDellimitter)'& [DATA_MONTH_SK]&
'$(vKeyDellimitter)'& [TERR_NBR]&
'$(vKeyDellimitter)'& AutonumberHash256(GEOGRAPHY_ID_NM))) as [%KEY_SUMMARY_PAYOUT]