Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
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
in the properties of the table make sure that
display zero values is unchecked
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.
I am checked that that one and it is ON mode
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
Hi Liron,
Your last expression was working Perfect.Thanks for giving good suggestion.
Regards
Suman