Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
BootCam
Creator
Creator

Eliminate/Hide value repetition in chart

Value Repetition:

Capture.PNG

The calculation for Notional amount is: Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHED}>}[Cost Amount])

The calculation for MTM Value is: Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHE}>}[TidMarkToMarket Open PL])

Now, we have cost amount which is not repetiting here but the MTM value is repetitive because of the association.

If you look at the total then you can see we are getting exact value for MTM. Its not adding up all the repeating values.

But i need to hide the repeating values from the UI.

Is there anyway i can do that from the UI?

Regards,

SK

5 Replies
ziadm
Specialist
Specialist

Hi

Use the expression Text color .. set the color to white if the value is equal above value ...

=if(Sum(sales) = Above(Sum(sales)),White(),Black())2.png

Anonymous
Not applicable

Most likely your chart is correct, and the repetitions have valid reasons.

The rows of the table are defined by the combination of chart's dimensions.  If you provide information about the dimensions, it would be easier to help you (if it is indeed necessary).

Possibly it can be done by removing a dimension form the chart, and replacing it with expression.

BootCam
Creator
Creator
Author

Hi Ziad,

It doesn't work with the expression you mentioned.

the original expression is for MTM: Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHE}>}[TidMarkToMarket Open PL])

I used this in the text color:

=if(Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHED'}>}[TidMarkToMarket Open PL]) =Above(Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHED'}>}[TidMarkToMarket Open PL])),White(),Black())


Still doesn't work.

Thanks,

Sk

ziadm
Specialist
Specialist

Hi SK

I am sure that you have a syntax mistake .. try to copy the formulas into expression and check the syntax  and see if yo getting results of the Above(sum ()) ...

Anil_Babu_Samineni

Interesting, Already mov provides valid and make sense too

Can you provide more information, I meant to say data or sample QVW, We can say ??

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)