Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Column Headers as Filter

Hi.  I have an excel data set where I have two columns called FYear (Fiscal Year) and CYear (Calendar Year).

Can I create a filter in QlikSense Cloud where I can choose whether to use Fiscal Year or Calendar Year to calculate sum of Amount?

SAMPLE DATA.jpg

 

1 Reply
emrekaya
New Contributor III

Re: Column Headers as Filter

Do you want to show them in a table or you just want to sum them up? If you want to see the summation of the values based on filters in a KPI, you can use crosstable