topic If condition with only() in QlikView

If condition with only()

Anonymous — Wed, 05 Aug 2015 10:00:36 GMT

hey all,

I am facing a problem with Rolling 12 months bar chart. I want the chart to show the avg for each month(for 12 month from the month selected). And default to the latest month for which the data is available(If no month/year is selected). The following is my expression :

If(GetSelectedCount([Month ])=0 and GetSelectedCount([Year ])=0,

Only({$<MonthYearID={"<= $(=$(vMax)) >= $(=$(vMax)-11)"},Location = {$(=SubField(GetfieldSelections(Location),':',-1))} >}R_AvgCardSwipes),

Only({$<MonthYearID={"<= $(=max(MonthYearID)) >= $(=max(MonthYearID)-11)"},Location = {$(=SubField(GetfieldSelections(Location),':',-1))} >}R_AvgCardSwipes))

The Only() expressions works fine when alone but not when used with the if condition.

Thanks .

Re: If condition with only()

sunny_talwar — Wed, 05 Aug 2015 10:05:40 GMT

Both Only expressions work stand alone? and both don't work when you make and clear selection???

Re: If condition with only()

Anonymous — Wed, 05 Aug 2015 10:21:17 GMT

Yes Sunny. Both expressions work when alone.

Re: If condition with only()

sasiparupudi1 — Wed, 05 Aug 2015 10:31:17 GMT

try

Only({$<Month =,Year=,MonthYearID={"<= $(=$(vMax)) >= $(=$(vMax)-11)"},Location = {$(=SubField(GetfieldSelections(Location),':',-1))} >}R_AvgCardSwipes),

Re: If condition with only()

Anonymous — Wed, 05 Aug 2015 10:42:08 GMT

Thanks. But there is no change.

Re: If condition with only()

sunny_talwar — Wed, 05 Aug 2015 10:43:34 GMT

Is the problem that it isn't giving you the result you expect or its just not giving any result???

Re: If condition with only()

Anonymous — Wed, 05 Aug 2015 10:50:40 GMT

From what I can interpret, Values get passed to variables in both the expressions. Both expressions are selected.

Re: If condition with only()

sunny_talwar — Wed, 05 Aug 2015 10:53:49 GMT

Well even if the value goes to both the expression, only one of the if statement clauses are going to be true. So either 1st expression or the 2nd expression is going to be evaluated.

What happens when you replace Only() with Avg(), May be there are more than one value to be displayed and Only just isn't possible.

Re: If condition with only()

Anonymous — Wed, 05 Aug 2015 11:12:35 GMT

Thanks Sunny. But the values are wrong .

I have found a work around. Instead of the if condition, I am using two charts with conditional hiding - One when no selection and other when there is a selection.

Thanks all.

Re: If condition with only()

sunny_talwar — Wed, 05 Aug 2015 11:14:16 GMT

May I suggest two expressions, instead of two charts? and conditionally hiding/showing them based on your condition. Just one less chart to worry about

HTH

Best,

Sunny

Re: If condition with only()

Anonymous — Wed, 05 Aug 2015 11:22:29 GMT

yes Sure.

Re: If condition with only()

sunny_talwar — Wed, 05 Aug 2015 11:26:31 GMT

Great

If you got what you were looking for, I would suggest closing this thread by selecting a correct answer and any helpful answers.

Best,

Sunny