topic Re: When do we use conditional expression?? Example ?? in QlikView

When do we use conditional expression?? Example ??

nikhilgarg — Mon, 03 Nov 2014 06:19:33 GMT

Hey,

When do we use conditional expression??

Can anyone plz tell me with an example ??

I am using personal edition of qlikview so can not open any other qvw.

Thanks

Re: When do we use conditional expression?? Example ??

its_anandrjs — Mon, 03 Nov 2014 06:31:06 GMT

Hi,

Let assume simple table where it has Year, Customers and Sales amount

1. Conditionally want Amount sum for only customer C2 and C3 then by SET analysis we can use

sum({<Customers={'C2','C3' }>} Amount)

2, Second conditionally want sum of from last year upto the records in DB

sum({<Year={'<=$(=Max(Year)-1)' }>} Amount)

Inline table

LOAD * Inline

[

Customers,Amount,Year

C1,4585,2011

C2,1256,2012

C3,1256,2013

C4,1256,2014

]

And tables

And there are so many condition and querys

Regards

Anand

Re: When do we use conditional expression?? Example ??

nikhilgarg — Mon, 03 Nov 2014 06:35:32 GMT

Hey,

Thanks but i am asking about when to use Conditional tab in Expression tab ??

Re: When do we use conditional expression?? Example ??

Mon, 03 Nov 2014 06:50:25 GMT

In ad-hoc report case you can use conditional expression

Re: When do we use conditional expression?? Example ??

vinay_hg — Mon, 03 Nov 2014 06:55:04 GMT

in simple eg. with if condition

for eg u are calculating tax on sold items.

if item is electronix 14% tax and cloths 5% and others 3% tax to be applied and have to show the total tax on items sold

now ur tax exp=

sum(if(itemtype='electronics', amount*0.14 , if(itemtype='cloths', amount*0.05, amount*0.03)))

something like this..

Re: When do we use conditional expression?? Example ??

vardhancse — Mon, 03 Nov 2014 07:10:00 GMT

In ad-hoc reporting will use conditional expressions.

Condition is that on selection of dimension & KPI they should be displayed in the chart.

We can keep layout condition that on at least one dim/KPI selection only chart can be displayed.

Re: When do we use conditional expression?? Example ??

its_anandrjs — Mon, 03 Nov 2014 07:28:13 GMT

There are many options for this but mainly we use the if conditions for the Conditions in Aggregation functions as well as any other functions also. I explain in example about the conditional expression where SET analysis works for select some set and deselect some set and give result. And in Conditional tab in which aspect you asking it in dashboard sheet or it is in any object.

Regards

Anand

Re: When do we use conditional expression?? Example ??

jagan — Mon, 03 Nov 2014 07:30:03 GMT

Hi,

Check this thread

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

Also check What's new in Qlikview 11 Demo file, and

Regards,

Jagan.

Re: When do we use conditional expression?? Example ??

jagan — Mon, 03 Nov 2014 07:30:48 GMT

Download that Dashboard using below link, you don't need license to open this file.

QlikView

and check the Reports tab.

Regards,

Jagan.

Re: When do we use conditional expression?? Example ??

nikhilgarg — Mon, 03 Nov 2014 07:33:29 GMT

HEy,

I am using Personal Edition so cannot open your attached .qvw at this link.

Can you explain here ??

Thanks

Re: When do we use conditional expression?? Example ??

its_anandrjs — Mon, 03 Nov 2014 07:38:42 GMT

Hi,

If you are using the QV version 11.0 or latest you can find the adhoc sample app in your system folder

C:\Program Files\QlikView\Examples\Documents

And its named Whats New in QlikView11.qvw you can get help of this app also in the Reports sheet.

Regards

Anand

Re: When do we use conditional expression?? Example ??

jagan — Mon, 03 Nov 2014 07:50:43 GMT

Hi,

You can use below link and check the Report tab, there it is implemented, you can download this and you don't need license for this.

ap-a.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FWhats%20New%20in%20QlikView11.qvw&host=demo11&anonymous=true

Regards,

Jagan.