topic Selecting a particular field in the table not working in QlikView

Selecting a particular field in the table not working

Hariprasath2394 — Wed, 25 Nov 2020 16:16:04 GMT

Hi @sunny_talwar . I have a new problem now. I have given the Customer number, Customer name and the year in the dimension and written the expression =sum({<FISCAL_YEAR={2020}, Customer_Name=e({<FISCAL_YEAR={2019, 2018}>})>}Orders). Please find the below screenshot. This table is showing me the Order value of customers only in the year 2020 but not in 2019 or 2018.

If I select a particular customer, it should show only that one customer's value right? For example, if I select the second customer 'IGET Industre', the table should show me only the order value of that specific customer. Instead, if I select that customer, the table gives me the list of all 2020 customers. If you see the below screenshot, the table is showing Order total value for all the 2020 customers when only one customer is selected. You have any idea why? Can you please help me?

Re: Selecting a particular field in the table not working

Kushal_Chawda — Thu, 01 Oct 2020 15:04:57 GMT

@Hariprasath2394 what is expectation?

Re: Selecting a particular field in the table not working

sunny_talwar — Thu, 01 Oct 2020 15:13:49 GMT

@Hariprasath2394 Try this

=Sum({<FISCAL_YEAR={2020}, Customer_Name *= e({<FISCAL_YEAR={2019, 2018}>})>} Orders

Re: Selecting a particular field in the table not working

Hariprasath2394 — Thu, 01 Oct 2020 15:18:19 GMT

Hi @Kushal_Chawda . My expectation is if I select a particular customer, it should show only that customer in the table. But in my case, it is not happening like that.

I need to see only 'IGET Industre' when I select it but not the entire table.

Re: Selecting a particular field in the table not working

sunny_talwar — Thu, 01 Oct 2020 15:30:36 GMT

@Hariprasath2394 did you get a chance to try the expression I provided above?

Re: Selecting a particular field in the table not working

Kushal_Chawda — Thu, 01 Oct 2020 15:49:41 GMT

@Hariprasath2394 then what sunny suggested should work

Re: Selecting a particular field in the table not working

jud1yian — Sat, 03 Oct 2020 10:54:22 GMT

I have the exact same problem. Have tried a variety of things upsers. Thanks!

Re: Selecting a particular field in the table not working

Hariprasath2394 — Mon, 05 Oct 2020 10:25:15 GMT

Hi @sunny_talwar it worked perfectly as I expected.😃 Sorry for the late reply. I had internet issues for the past three days. What does the expression *= mean? Just including a * changed the selecting option. Thanks a lot for your guidance.

Re: Selecting a particular field in the table not working

Hariprasath2394 — Mon, 05 Oct 2020 10:26:46 GMT

Try what @sunny_talwar gave as a solution. It worked perfect for me.

Re: Selecting a particular field in the table not working

sunny_talwar — Mon, 05 Oct 2020 12:37:57 GMT

@Hariprasath2394 check here

Implicit Set Operators

Re: Selecting a particular field in the table not working

Hariprasath2394 — Mon, 05 Oct 2020 12:38:42 GMT

Thanks a lot again @sunny_talwar

Re: Selecting a particular field in the table not working

sunny_talwar — Mon, 05 Oct 2020 12:45:46 GMT

@Hariprasath2394 no problem, I am glad I have been able to help