topic Re: Cyclic Group with if statement - Selection selects > 1 field in QlikView

Cyclic Group with if statement - Selection selects > 1 field

tschullo — Thu, 02 Oct 2014 15:41:37 GMT

I have a sales budget dashboard that with three panes (charts) . The first has the cyclic group with sales person as one dimension and customer as the second and includes data for EXISTING budgeted customers. The second has sales person as the dimension and shows data for NEW customers only. The third shows the totals by sales person.

My issue was that in the first pane for EXISITING data, NEW customers were being listed along with the EXISTING customers, but only if I didn't filter by a specific sales person. If I select a specific salesperson, the "exclude zero values" rule applies, but if I don't it is ignored (and the values are zero)..

So I added an IF statement to my cyclic group: =if(FYbudgetCode<3, [CustomerName]). //where 3 is NEW

So now when I select a customer name, the current selections box shows my customer as selected as well as "FYbudgetCode = 2".

I don't want FYbudgetCode to be selected.

Can anyone please help me with this?

Thanks,

Tony

Re: Cyclic Group with if statement - Selection selects > 1 field

Gysbert_Wassenaar — Fri, 03 Oct 2014 09:55:06 GMT

Perhaps you can use set analysis expressions instead of messing about with calculated dimensions. Suppose you now have an expression sum(Sales). To exclude new customers you could change it to sum({<FYbudgetCode={'<3'}>}Sales).

Re: Cyclic Group with if statement - Selection selects > 1 field

tschullo — Tue, 07 Oct 2014 14:42:47 GMT

Than you, Gysbert!

You got me thinking along the right direction. The reason it was not working when I had multiple salespeople is because I had added two columns outside of the main view of the chart where I neglected to wrap the field in an "only()" statement that filters them down to EXISTING.

Thanks for responding.