topic Re: Requesting Pros regarding conditional functions in QlikView

Requesting Pros regarding conditional functions

Anonymous — Fri, 03 Jul 2015 06:41:23 GMT

Conditional Functions:

-----------------------

We all do know what the syntax of conditional statements are , but we are with less number of resource documents in community , i request pros to contribute something regarding this, robert mika i ve been using your resource documents and i found them very useful ,hope you take some time in this also ,i hope everyone come up with different scenarios and new ways of using them .cheers all Robert_Mika gwassenaar hic jagan

if(condition , then , else)

alt(case1[ , case2 , case3 , ...] , else)

pick(n, expr1[ , expr2,...exprN])

match( str, expr1 [ , expr2,...exprN ] )

mixmatch( str, expr1 [ , expr2,...exprN ] )

wildmatch( str, expr1 [ , expr2,...exprN ] )

class(expression, interval [ , label [ , offset ]])

Thanks,

QvhelpPlease

Re: Requesting Pros regarding conditional functions

Siva_Sankar — Fri, 03 Jul 2015 06:47:32 GMT

Refer the blog

https://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use#start=25

Re: Requesting Pros regarding conditional functions

hic — Fri, 03 Jul 2015 07:39:21 GMT

The first thing you should as yourself when you have a conditional expression is: Can this problem be solved with Set Analysis?

The reason is that Set Analysis is always faster if the data amount is large. Hence, Set Analysis should be the preferred solution for conditional aggregations. See

Conditional Aggregations

Performance of Conditional Aggregations

The second question is: Can I prepare some of the calculations in the script, so that less calculations are made during the actual session?

If you in the script create Boolean fields - flags - the calculations in the UI will be faster and easier to express. See e.g.

On Boolean Fields and Functions

Year-over-Year Comparisons

HIC

Re: Requesting Pros regarding conditional functions

Anonymous — Fri, 03 Jul 2015 07:44:18 GMT

thanks for your help HIC hic‌