topic Re: Multiple selection Issue in QlikView

Multiple selection Issue

Fri, 08 Aug 2014 14:06:59 GMT

Hello,

I am having a month field with 1, 2,3....11,12.

I am using a condition as

if(MonthField >= num(month(quarterstart(date(MonthField)),'0'), A,B)

This is working fine if I select 1 value in Month Field, But If I select 2 MonthField Values (ex: 1 and 2). I am not getting the result. How should I use this condition on multiple MonthField Selections.

Thanks

Re: Multiple selection Issue

its_anandrjs — Fri, 08 Aug 2014 14:21:32 GMT

Please provide some sample data with output will be easy to help out.

Re: Re: Multiple selection Issue

Fri, 08 Aug 2014 15:01:18 GMT

I need to get totals in Straight Table when two Month values are selected

Re: Multiple selection Issue

JonnyPoole — Fri, 08 Aug 2014 15:05:47 GMT

i think you need a chart aggregation expression in your THEN and ELSE clauses like this for example:

=If(Month >=num(month(quarterstart(date(today())))),sum(A),sum(B))

Re: Multiple selection Issue

Anonymous — Fri, 08 Aug 2014 15:06:44 GMT

in the expressions tab, under "Total Mode", use Sum of rows instead of Expressions Total. that should do it.

Re: Multiple selection Issue

Fri, 08 Aug 2014 17:39:18 GMT

I think, I am having problem in explaining the issue. I am attaching QVW file. I need the values in 2nd Text object when 2 Month Field Values are selected which are greater than this QuarterStart Date. It ll be more clear if you look into the expressions I used.

Re: Multiple selection Issue

JonnyPoole — Fri, 08 Aug 2014 17:42:31 GMT

changed the text box expression too...

= sum( If(Month >=num(month(quarterstart(date(today())))),A,0))

Re: Multiple selection Issue

Fri, 08 Aug 2014 17:48:38 GMT

I am getting an error because Nested aggr functions cannot be used.

In my actual application In place of A I have Sum() inside that I have lop of set analysis. Is there any other approach?

Thanks

Re: Multiple selection Issue

JonnyPoole — Fri, 08 Aug 2014 17:52:21 GMT

Then you may need to wrap what you have in a Sum( Aggr( <whatyouhave> , <dimension> )) expression. since its a text box, perhaps try 2 single quotes '' as the <dimension> value.