How to show Sales persons base on category wise in a month

[Anonymous]

Dear Qlik,

I have one data source . In that i want to show Sales persons base on category wise in a month and The straight table shows only one category ,Remaining not shown in table(i,e. For example i want to shows Yellow Category at that time shows only Yellow category Sales persons in a month.) I am attaching source data  and my output is below jpeg model in straight table.

Thanks inadvanced

Regards

suman

[lironbaram · Accepted solution]

hi

it's not exactly clear what you look for

if you make a selection of category than the table display only this category data,

if you want it to display only specific category you have two options

=sum(if(Category='Yellow',score))

or

=sum({<Category={"Yellow"}>},score))

[Anonymous]

HI Liron,

Thanks for reply. I am using your expression it shows Exact values what i want to show but remaining all values are shown in table '0's. I want to remove this '0' values and shows only that category data.

Regards

suman

[lironbaram]

in the properties of the table make sure that

display zero values is unchecked

[Anonymous]

hi liron

one more problem is when iam selecting green,the values shows green,yellow,red values in the straight table.

please give me a suggestion on this.

[Anonymous]

I am checked that that one and it is ON mode

[lironbaram]

hi

do you have more than one expression in your table

can you describe what excatly you need

because it sounds you can just allow the user to select category and then he'll see only the results relevant to the category he selected

[Anonymous]

Hi Liron,

Your  last expression  was working Perfect.Thanks for giving good suggestion.

Regards

Suman