Hiding columns

[Emmcee]

Good morning all I'm a total novice so will welcome any help you can offer.

I have started to create a report in Qlik but need some help with hiding columns

I'm trying to compare values for current against previous year. My fields consist of Actual Sales and Budget I need the Actual Sales to be shown for both years but I only need the current year's Budget figures to be shown. Is this possible to do?

[tresB]

@Emmcee ,

Could you explain with an example of data set and expected output for that?

[Emmcee]

Sorry I told you I was a novice!

Actual Units               Budget            Actual Sales             Budget

2019     2020   |   2019      2020      |    2019     2020    | 2019     2020

100         120     |    85          100        |   275        325       |    200       250

So I want to keep the 2019 Actual Units and Actual Sales value but I only want to show the 2020 Budget value in both cases. Does this make sense?