General guidance to learn to write Syntax properly

[Applicable88]

Hello,

maybe you feel the same and have some tips and tricks.

I really struggle with writing the syntax correctly.

For example it doesn't make sense to me why e.g. in a If -function like : if( Amount>= 0, 'OK', 'Alarm' ) 

As you can see , even if amount is a column expression, you don't need to put it in Brackets like [  ] or curved brackets.

But in other expression you need to do it.  For example in set analyst you need angle bracket and curved. 

or here:

For example

Load

Date([Sales]) as Sales.......

Maybe someone know where to get the hang of  out it like here: 

Only({<Umsatzmonat={"$(=Date(today(),'MM.YYYY'))"}>} Umsatzziel)

  Where to learn it fast besides the Qlik helpage? I don't find the language easy to understand. 

Maybe someone wants to share with me.

Stay safe and thanks in advance. 

[pedrobergo · Accepted solution]

Hi @Applicable88 

Qlik has a BNF codification, and maybe you have to read some about it. See these links

• What is Backus-Naur formalism?
• Syntax for sets

I understand that you don´t agreed with that and i´m feel the same with other languages. The Set Analysis syntax has some differences with Qlik script, but out of Qlik Help, you can learn it from these links.

• Udemy Course: https://www.udemy.com/course/mastering-qlikview-set-analysis/
• QCC Course: https://learning.qlik.com/enrol/index.php?id=1500 and https://learning.qlik.com/enrol/index.php?id=1504
• Tips & Tricks: https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

Good luck,

Pedro

[Applicable88]

Hi @pedrobergo ,

thank for your effort. Really appreciate for the links!

Stay safe !

Best,

King88

[Applicable88]

BTW Pedro,

the link to the Udemy Course you gave me....its about Qlikview.

We solely using Qlik Sense in the cloud in our company. 

I really like Qlik courses. Are most of the content in that course also applicable to Qliksense? 

Best,

King88