Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Master Item Function - Average of Total

I need a master item which will function as an If statement.

Vendor Small.PNG

I have a series of values, each with a yes of a no. How do I add a master item which would tell, if yes for column A, then total. That total would then need to be divided the total of every possible value. So ideally it would would give you percentage of spend fulling under that specific category.

I am not able to adjust the excel sheet, or I would just make the changes there. Even when I try to do a simple average master item it says it is an invalid dimension.

Your help is most appreciated

1 Reply
Not applicable

Re: Master Item Function - Average of Total

My goal is to display the chart like this:

Output - Average.PNG