Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

Writing Expressions

Hi Experts,

I am beginner in Qlikview. I always get stuck while writing expressions. I want to become comfortable in this area rather than getting intimidated. Could you please guide the resources from where I can start learning them, like understanding structure, functionality, using multiple expressions in the same formula etc..

Regards,

Suraj

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Hello Suraj,

Assuming that you are from computer science background. If not, I would suggest you to learn first and foremost a basic programming language like BASIC/C. Specifically the loops (IF-THEN-ELSE, FOR, DO-WHILE). Then learn some basics(Primary Key, Joins, Normalization ...) of database. This will give you basic strength to move to QlikView development world. Once you are armed, try to understand how various concepts like Set Analysis, AGGR, Count(If()) Vs If(Count()) work; what is the approach of evaluation of expession. You would get materials for these in the forum. But my suggestion would be to try different combinations with those expressions on your own. This littile R&D would give you a lot more confidence and you would hardly forget the learning got in your practical experience.

Try yourself again and again to break and at last community is there for you.

View solution in original post

9 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Suraj,

Practice all the expressions with examples in the Set Analysis section of the Qlikview Help file, it covers all the set analysis topics, and then Practice more, Practicing hard will give you command over Set Analysis.  Hope this helps you.

Use below URL to generate Qlikview expressions.

Set Analysis Wizard for QlikView | qlikblog.at

Regards,

jagan.

Anonymous
Not applicable

As a start, Look for Reference Manual here in the forum.

Regards.

Clever_Anjos
Employee
Employee

I would start with free training at qlik.com,

Then I would buy "Practical QlikView"  by Mark O´Donovan its a very usefull book

http://www.amazon.com/Practical-QlikView-Mr-Mark-ODonovan/dp/1478158603/ref=sr_1_1?ie=UTF8&qid=13804...

tresesco
MVP
MVP

Hello Suraj,

Assuming that you are from computer science background. If not, I would suggest you to learn first and foremost a basic programming language like BASIC/C. Specifically the loops (IF-THEN-ELSE, FOR, DO-WHILE). Then learn some basics(Primary Key, Joins, Normalization ...) of database. This will give you basic strength to move to QlikView development world. Once you are armed, try to understand how various concepts like Set Analysis, AGGR, Count(If()) Vs If(Count()) work; what is the approach of evaluation of expession. You would get materials for these in the forum. But my suggestion would be to try different combinations with those expressions on your own. This littile R&D would give you a lot more confidence and you would hardly forget the learning got in your practical experience.

Try yourself again and again to break and at last community is there for you.

MayilVahanan

Hi

Please refer this

http://community.qlik.com/docs/DOC-4951

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
israrkhan
Specialist II
Specialist II

Hi Suraj,

see these links on youtube..

Alan Farrell - YouTube

QlikTips - YouTube

Qlik Share - YouTube

see these videos , they will help a lot..

Khan

vikasmahajan

pfa THIS DOCUMENT WILL HELP YOU LOT

gOOD LUCK

VIKAS

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
AbhijitBansode
Specialist
Specialist

I would suggest to go through the Qlikview help file.

Study the Set Analysis, all types of functions carefully.

you can also use Set Anlysis Wizard  to write expressions including complex set analysis.

v_iyyappan
Specialist
Specialist

Hi,

Please refer following link to learn write the expression.

Writing Expression

Writing Expressions...

Regards,