Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

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
Partner
Partner

Show Part (as a dimension) corresponding to Min Value in a Pivot/Straight Table

clipboard_image_0.png

In the 2nd straight table, I want to display the dates and the Min Value across all parts for that date and the Part corresponding to the Min Value for that date.

I am able to do it as shown above but the Parts are displayed as Measures and thus are not selectable. I would like to click on a particular part in the table (highlighted in yellow) thus filtering the dataset to that part.

Is this possible?

QVF is attached.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

If in the straight table, we use Dt and Part as dimensions and

"

if(
sum(Value)=
min(Total <Dt> aggr(sum(Value),Dt,Part,Group)),
sum(Value),
0
)

" as the measure with suppress zero value. Would it work?

View solution in original post

6 Replies
Highlighted
Creator III
Creator III

create  a dimension as below

=aggr(firstsortedvalue(Part, Value), Dt)

Highlighted
Partner
Partner

clipboard_image_0.png

I do see the part numbers as dimensions with your approach. But when I select the part number, it makes a selection on Dates as seen in the above screenshot.

Highlighted
Creator III
Creator III

This selects both dt and part

=if(aggr({1}rank(-sum(Value)),Dt,Part)=1,Part)

 

hopefully there is a better way

 

Highlighted
Partner
Partner

@sunny_talwar any other approach?

Highlighted
Partner
Partner

Hi,

If in the straight table, we use Dt and Part as dimensions and

"

if(
sum(Value)=
min(Total <Dt> aggr(sum(Value),Dt,Part,Group)),
sum(Value),
0
)

" as the measure with suppress zero value. Would it work?

View solution in original post

Highlighted
Partner
Partner

Hi,

Have incorporated the logic in the load script, hope this helps

Regards

Shashi