Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

How to use separate display for dimension field

Hi,

We have Qlikview app and data looks like below. There are many measures for our incentive program, most measures are similar year over year, and we keep three year data in our app. Below m1 measure is same measure for year 2019 and 2020, but there may contain some rule change or different explanations for 2020 - you can see the note number changed.

YearMeasureIDMeasure NameMeasureNote
2019m1Something Compliance Something Compliance¹·⁵·⁶ 
2020m1Something Compliance Something Compliance¹·⁵

 

I took a few columns for Aug 2020 report from one straight table. The dimension 'Measure' is actually 'MeasureNote' from data. For same m1, MeasureNote is actually not same for year 2019 and 2020. So Last YTD rate and Last Yearend rate are both missed. (Last yearend rate is something like: Sum({$<Year = {$(vPriorYear)}, Month = {'DEC'},>}[# Numerator]) / Sum({$<Year = {$(vPriorYear)}, Month = {'DEC'}>}[# Denominator]))

Aug 2020 report by MeasureNote:

MeasureCurrent Num/DenCurrent RateLast YTD RateLast Yearend Rate
Something Compliance¹·⁵80/10080%  

 

If I use Measure Name (Or MeasureID) as dimension then all fields were populated. Is that possible we can user MeasureID or Measure Name as dimension but display as MeasureNote, so all fields can be populated properly? Or any way to force last year rate calculations only based on MeasureID/Measure Name instead of dimension which is MeasureNote?

MeasureCurrent Num/DenCurrent RateLast YTD RateLast Yearend Rate
Something Compliance80/10080%78%85%

 

Thanks in advance.

Fion

Labels (3)
1 Solution

Accepted Solutions
Specialist
Specialist

Hi,

This may take a bit of tweaking, but I think you can use P() function in your set analysis, so use MeasureNote= to ignore selection on MeasureNote & then [Measure Name]=P([Measure Name]) to add to the set possible values of Measure Name, similar to screenshot  below;

20201006_1.png

Let me know if that does not help.

Cheers,

Chris. 

View solution in original post

2 Replies
Specialist
Specialist

Hi,

This may take a bit of tweaking, but I think you can use P() function in your set analysis, so use MeasureNote= to ignore selection on MeasureNote & then [Measure Name]=P([Measure Name]) to add to the set possible values of Measure Name, similar to screenshot  below;

20201006_1.png

Let me know if that does not help.

Cheers,

Chris. 

View solution in original post

Creator
Creator

Hi Chris,

this works! Thank you very much.

Fion