Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

showing specific values of the whole dataset based on a selection

Hey all,

for our Quality Department I would like to establish the following analysis:
We have notifications that are linked to a materialnumber which is affected by some specific error. If a quality manager selects a specific notification, I would like him to see all the notifications where the linked materialnumber has also occured:

Using the table below, by selection notification 1, I would like qlikview to create a graph which shows the notifications 1,4,6,8 and 10 since they are all about the same material.

YearNotificationMaterial
20101X
20102Z
20103Z
20114X
20115Z
20126X
20137Z
20148X
20149Z
201510X

Thank you for your efforts!

best,

Sebastian

4 Replies
pulkit1611
Contributor II

Re: showing specific values of the whole dataset based on a selection

Not Sure why u are taking Notification number as dimension when you could easily choose material to see all related Notifications.

Re: showing specific values of the whole dataset based on a selection

Create variable on frontend vMaterial and put below expression

= Material

Select any notification

Now use below expression in chart

=sum({<Material={"$(=vMaterial)"},Notification=>}Amount)

Not applicable

Re: showing specific values of the whole dataset based on a selection

The use case is, that an analyst examines one specific notification where the development of the material within this notification shall be shown over the dimension year/month as additional information.

MVP
MVP

Re: showing specific values of the whole dataset based on a selection

You can use p() here. PFA

Exp used: Sum({<Notification, Material=P(Material)>}1)

Untitled.png

Community Browser