topic Re: Information about syntaxes in QlikView

Information about syntaxes

Thu, 09 Aug 2012 08:11:17 GMT

I have been studying clickview for the last week now but ik cannot really seem to figure out how the syntaxes work and what they exactly do.. Sometimes they work and sometimes they don't.

Does somebody have a website or a manual which could help me figure this out?

I did find a very helpfull website, but it helps me make the syntaxes and not understand them

Kind regards

Re: Information about syntaxes

Anonymous — Thu, 09 Aug 2012 08:31:46 GMT

you can check the QlikView help in the application. For explainantion about the syntax and their use..

Re: Information about syntaxes

Thu, 09 Aug 2012 09:15:08 GMT

Hope the following things helps...

1. Please refer C:\Program Files\QlikView\Documentation\QlikView Reference.pdf

2. Read all the discussion in QlikCommunity. Which will help alot!

3. Go through Rob Wunderlich cookbook: http://community.qlik.com/thread/29413

4. Go through QlikView help in the application.

5. Refer http://qlikshare.com/

Re: Information about syntaxes

hic — Thu, 09 Aug 2012 09:42:15 GMT

If you are new to QlikView, you should not use Set Analysis (which is what is described on the helpful website). Set Analysis should really not be used unless you have very complicated expressions that need other selections (filter settings) or two or more selections at the same time.

Just load the data in the script using simple Load or Select statements. Then create your charts using simple aggregation functions as expressions, e.g. Sum(Sales). This approach will solve 95% of all calculations.

HIC

Re: Information about syntaxes

Thu, 09 Aug 2012 13:41:27 GMT

I am affraid i have to use the Set Analysis, there is no other way to calculate the aggregate data used in a specific month by a specific datauser group. This is especialy true for the dashbord with gaugemeters that we need.

Next month i have a two day qlikview training as designer and 3 day as developer.. The more i learn before, the more advanced i wil get in the course!