topic Similar Banding for 2 different KPI's in QlikView

Similar Banding for 2 different KPI's

nikhilgandhi715 — Wed, 13 Aug 2014 09:08:21 GMT

Hi All,

In my database I have two amount columns 1. Quoted Amount 2. Sale Amount. I need a similar banding for both the amount columns. The banding i currently have is on my quoted amount such as '0-1000','1000-2500' etc. The issue I am facing here is as the banding is based on the quoted amount if I select any band my Sales chart displays incorrect values or msg 'No data to display'.

What I want is a column as Banding which would work for both the amount columns.

I have tried inserting two different columns in the data model which links to the amounts however it creats a circular reference also it increases my application size which I can not afford.

Any help will be much appreciated.

Thanks in advance.

Re: Similar Banding for 2 different KPI's

Wed, 13 Aug 2014 09:11:55 GMT

Hi Nikhil,

Can you please attach your sample qvw?

Thanks

Sabal

Re: Similar Banding for 2 different KPI's

nikhilgandhi715 — Wed, 13 Aug 2014 09:18:04 GMT

Hi Sabal,

The data size is above 250 MB. I shall try and create a sample and upload.

Thanks,

Nikhil

Re: Similar Banding for 2 different KPI's

Wed, 13 Aug 2014 09:21:21 GMT

Hi Nikhil,

Yes, that would help.

Thanks

Sabal

Re: Re: Similar Banding for 2 different KPI's

nikhilgandhi715 — Wed, 13 Aug 2014 09:36:39 GMT

Hi Sabal,

Please find attached file.

In the file I have a single banding which works on the Quote amount. What I want is that same band should also work for the Sales amount.

Thanks,

Nikhil.