Display N/A when transactional level is selected

Sunil_Kenth — Wed, 31 Aug 2011 13:00:52 GMT

I would like to display 'N/A' in the 'budget' column when i select a transactional level record

Attached is a trial QVW and data I was using to try and resolve a problem lining up Actuals recorded at transactional levels against a budget which is recorded at a balance/aggregate level.

Summary views are ok e.g.

Year Period Account Act Bud

2010 1 123400 120 100

2010 2 123400 115 100

Until you drill down to something more granular on the actual e.g. drill on a specific actual date e.g. 31/07/10

Year Period Account Act Bud

2010 1 123400 7 100

2010 2 123400 0 100

In this context the Budget is no longer valid. I have tried playing with the function GetFieldsSelection(Fieldname) to check whether the current drilldown is on a field which is beyond the granularity of the Budget and if it is set budget to N/A. Unfortunately you have to nest a lot of conditions covering all the fields you could drill down on which are not Budget fields.

(See the Summary Table on Sheet1 tab, expression rev_bud)

My next port of call was to conditionally suspend the column in the presentation tab of the properties but couldn’t get it to work and you still need the nested conditions.

Any thoughts would be great.

Re: Display N/A when transactional level is selected

Wed, 31 Aug 2011 13:29:45 GMT

View attached file.

I use pivot table and dimensinality() function.

topic Re: Display N/A when transactional level is selected in QlikView

Display N/A when transactional level is selected

Re: Display N/A when transactional level is selected