topic Contract buckets based on Country in QlikView

Contract buckets based on Country

madhuqliklondon — Sat, 16 Nov 2024 00:17:45 GMT

Hi all,

I am trying to bucket some of the contract information explained in excel, I have tried with where column name = column name and few examples looking at community but nothing seems to be working as expected. I can create a calculated dimension but I would like to use this in set analysis.

Few details on the request

A sim contract has a contract type and it can be paid or free, where the contract is issued is a country of origin and they can visit any country as a roaming country. for example if we take UK customers they can use the sim in the UK or they can visit eligible roaming countries and vice versa. So I am trying to bucket these scenarios. please see the excel attached (apologies for the poor analogy).

Thanks in advance.

Re: Contract buckets based on Country

NitinK7 — Mon, 20 Jul 2020 09:05:36 GMT

Hi,

find below attached application.

Re: Contract buckets based on Country

madhuqliklondon — Mon, 20 Jul 2020 10:16:24 GMT

Hi Nitin,

Thank you very much for your time and support, very useful logic, can you check last 2 expressions please, they must be kind of the opposite, like Inbound Vs Outbound. Please see attached file, I have updated with comments.

Re: Contract buckets based on Country

NitinK7 — Mon, 20 Jul 2020 10:25:44 GMT

Hi,

Sorry I did't understood , can you please explain in brief .

Re: Contract buckets based on Country

madhuqliklondon — Mon, 20 Jul 2020 10:45:46 GMT

Hi Nitin,

sure, if we take the UK as an example

No of visits of Free contracts in that country (where issued in another country) In: Counting free customers visits visiting the UK, their country of origin is Not the UK.

No of visits of Free contracts in another country (where issued in this country) Out: Counting free customers visits visiting other countries from the UK, their country of origin is the UK.

hope this makes sense. Thank you