Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Cyclic Group IF Statement Expression

Hi,

I need of some help.

I have a chart with a Cyclic group dimension. The cyclic group contains 5 dimensions in which one of them is an expression.

In expression I have created an If statement is used to calculate the Sales Person as depending on the Company selected the Sales Person is taken from User ID1 or User ID3.

The if statement is:

If(Company = 'France', [User ID1], [User ID3])

This appears to work fine and when I select France and view the cyclic group by the Sales Person I get the correct results. However as soon as I select a Sales Person the chart shows a completely different and incorrect sales figure.

I figured out why this is happening from the current selections box. As soon as I select a Sales Person that person is selected in both [User ID1]  and [User ID3]. If I clear the [User ID3] selection then I get the correct results. I have added in list box's for both User ID's and selected the Sales Person from each list box and it works fine so I believe the issues lies with the Cyclic Group if statement expression.

Any help on this is much appreciated?

Thanks,

Nikki 


1 Reply
Highlighted
Honored Contributor II

Re: Cyclic Group IF Statement Expression

Hi.

Why do you have separate user id fields ? Where do you select Sales Person ?

Could you share an example ?