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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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