Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculating % in trend graph

Hello,

Find qvw file. How can i use listbox to exclude items in trending line chart.

Emar

5 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps with this expression: Count ({<Function = E(Function)>} Item)/ Count ({<Function>} Item)*100


talk is cheap, supply exceeds demand
Not applicable
Author

There is field for exclusion. For the expression

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

There is field for exclusion. For the expression

Sorry, but I have no idea what you're trying to tell me here.


talk is cheap, supply exceeds demand
Not applicable
Author

One of the expressions holds complete % of all item except "None" why the other expression works with the exclusion list-box such that when an option is checked it increases the %. Also date is my default dimension.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Sorry, this is getting more confusing instead of less. I have no idea anymore what problem you're trying to solve.


talk is cheap, supply exceeds demand