Display only columns with filtered value

Matt — Sat, 16 Nov 2024 04:21:09 GMT

Hello, i have a table f.e. like this

Name_of_bank | Total_count | Year 2017 | Year 2018 | Year 2019

ING | 2 | 2 | 0 | 0

Erste | 5 | 1 | 2 | 2

And so on.. In filter I choose Year 2017.

My questions is, is it possible to display in the table only column Year 2017. If I choose different year, display only filtered year.

If not, do you have an idea how to do so?

Thank you in advance.

Re: Display only columns with filtered value

jonathandienst — Mon, 25 Feb 2019 13:57:11 GMT

Perform a cross table load to convert your cross table to a conventional table for analysis.

Result:
CrossTable(Year, Value, 2)
Load Name_of_bank, Total_count, Year 2017, Year 2018, Year 2019
From ...

If you would like the years as numbers, you need one more step:

T_CROSST:
CrossTable(T_Year, Value, 2)
Load Name_of_bank, Total_count, Year 2017, Year 2018, Year 2019
From ...

RESULT:
LOAD Name_of_bank, 
	Total_count,
	SubField(T_Year, ' ', 2) as Year,
	Value
Resident T_CROSST;

Now you can create a list box with Year and see the results for the selected year.

topic Re: Display only columns with filtered value in QlikView

Display only columns with filtered value

Re: Display only columns with filtered value