Display Chart based on field value - Qlik Community

Report Inappropriate Content · ‎2012-12-07

I am having a straight table, I want to display rows based on one dimension......where that value is equal to 1.........where can I give the condition........

MayilVahanan · ‎2012-12-07

HI

Try like this

=Sum({<DimesionField = {1}>}Sales)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

jagan · ‎2012-12-08

Hi,

Try this

=Sum({<YourDimensionName={1}>} Revenue)

Here YourDimensionName={1}, filters the dimension having value 1.

Hope this helps you.

Regards,

Jagan.

Report Inappropriate Content · ‎2012-12-11

Hai Jagan

i have two tables one is ID Sales

1 1A

2 2A

3 3A

i create the one varible vshow which is usefull for entering the values through Input Box

vshow-----1A,2A if i entered that shown in stright table how can please urgent boss

sales sales

1A 3A

2A or 1A Randomely i am going to entering the value s

Report Inappropriate Content · ‎2012-12-11

Hai Jagan

i have two tables one is ID Sales

1 1A

2 2A

3 3A

i create the one varible vshow which is usefull for entering the values through Input Box

vshow-----1A,2A if i entered that shown in stright table how can please urgent boss

sales sales

1A 3A

2A or 1A Randomely i am going to entering the value s

Report Inappropriate Content · ‎2012-12-11

i have two tables one is ID Sales

1 1A

2 2A

3 3A

i create the one varible vshow which is usefull for entering the values through Input Box

vshow-----1A,2A if i entered that shown in stright table how can please urgent boss

sales sales

1A 3A

2A or 1A Randomely i am going to entering the value s

jagan · ‎2012-12-12

Hi Surik,

PFA attached file. Hope you will find the solution. If this post helps you, close this discussion by clicking Correct Answer button.

Regards,

Jagan.