calculated dimension

shariqusmani — Wed, 25 Nov 2020 16:16:04 GMT

Hello Friends,

Trying to figure this out but having trouble.

I have a chart that shows In Force policies by Broker for the current period and the year before. Like so

Broker Name 2016-06 2017-06

A 500 600

B 200 300

and so on...

I have this set up by assigning a variable vCurrentDate as the current date and the year before is calculated as AddYears(vCurrentDate,-1). This is a calculated dimension set up as

if(InforceDate = $(vCurrentDate) or InforceDate = AddYears(vCurrentDate,-1), InforceDate)) and then suppress null values.

The issue is that the data is coming from two different systems. System 1 is updated as of June 2017 but System 2 is as of May 2017 and will not update until 15th business day. So currently in the chart above, if say Broker C is from system 2, it will show 0 under 2017-06.

So no problem with System 1 but how do I modify the calculated dimension so that it shows 2016-05 and 2017-05 if a user selects a broker that happens to come from System 2?

Should I be using set analysis instead of calculated dimensions? I feel this may be simple but confused.

Any help is appreciated.

Shariq

Re: calculated dimension

sunny_talwar — Wed, 12 Jul 2017 01:04:07 GMT

I would suggest you to use set analysis to do this rather than using calculated dimension.... as per the specific requirement, it might be easy if you are able to share a sample...

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: calculated dimension

Anil_Babu_Samineni — Wed, 12 Jul 2017 01:43:30 GMT

Because, in your system 2 you have updated May 2017 only. How you are expecting Jun 2017 value even you don't have data for that?

topic calculated dimension in QlikView

calculated dimension

Re: calculated dimension

Re: calculated dimension