Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Dynamic measure column selection based on period selection in filter

I have a data where Period calculations such as MTD, QTD, YTD are mentioned in separate columns in back end data. I want to add a filter in front end as MTD, QTD, YTD and then want all charts in sheet to be populated as per flter selection and take values from correct columns. For example - If I select QTD in filter, all charts should refer to QTD column in the back end and return the correct values for selected period.

3 Replies
Highlighted

Check This

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor
Contributor

Thanks Anil for your quick response, However this looks quite bigger change as i needs changing back end data model.

I have already developed few charts and it would be very helpful if I can achieve it using Set Analysis or any expressions. I worked on tableau before and there you can simply use parameters and use If condition to dynamically change measures.

Any help to achieve this in other way?

Highlighted
Specialist II
Specialist II

can you post your application and an excel view of what you are trying to achieve?

It's easier to help you if you give access to your dashboard