Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
skh
Contributor

Display N/A when transactional level is selected

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.

1 Reply
Not applicable

Re: Display N/A when transactional level is selected

View attached file.

I use pivot table and dimensinality() function.