topic Re: How to hide dimension value when a column ignore the selection of this dimension? in QlikView

How to hide dimension value when a column ignore the selection of this dimension?

chenriot — Fri, 18 Mar 2016 15:50:56 GMT

Hi,

I have a straight table with one dimension "reps" and 2 expressions :

- one that sum revenue

- one that sum revenue for all reps (so with ignore reps selection in set analysis).

My problem is that when I select one rep, all reps are displayed in the table with only the first expression calculated for the rep I selected and the second expression is calculated for all reps. I would like only the line with the rep selected displayed in the table.

In the example below, I would like only the line with Rep5 displayed.

How can I do this ?

Thanks in advance for your help

Re: How to hide dimension value when a column ignore the selection of this dimension?

alexdataiq — Sat, 19 Mar 2016 00:04:25 GMT

You can go to the Expression Tab and check the conditional box and use the expression:

If(GetSelectedCount(Rep) >= 1, 0, 1)

Regards

Re: How to hide dimension value when a column ignore the selection of this dimension?

MarcoWedel — Sun, 20 Mar 2016 01:28:19 GMT

please post a sample application

regards

Marco

Re: How to hide dimension value when a column ignore the selection of this dimension?

kkkumar82 — Sun, 20 Mar 2016 04:24:27 GMT

Hi,

If you want the thing what you required then where are you using the second column.

Better post sample qvw with some dummy data.

Thanks

Kiran K

Re: How to hide dimension value when a column ignore the selection of this dimension?

Kushal_Chawda — Sun, 20 Mar 2016 05:29:26 GMT

What is the expressions for Total revenue and revenue?

Re: How to hide dimension value when a column ignore the selection of this dimension?

jagan — Mon, 21 Mar 2016 03:25:01 GMT

HI,

Try like this

Expression -> Select Conditional -> and give below expression

=GetSelectedCount(Rep) = 0

I think there is no meaning of adding the second expression if you are hiding when Rep is selected.

Regards,

Jagan.

Re: How to hide dimension value when a column ignore the selection of this dimension?

tyagishaila — Mon, 21 Mar 2016 06:50:52 GMT

What is the use of Total Revenue?... if you don't want to show all reps after any rep selection.

Re: How to hide dimension value when a column ignore the selection of this dimension?

chenriot — Mon, 21 Mar 2016 09:36:05 GMT

Hi,

thanks for all responses.

In fact, I have 2 problems :

1. In the example, I would like the "total revenue" column with the value 420 (sum of revenue without take care about the rep selected)

2. I would like only the row displayed for the rep selected.

This is the result I would like :

Thanks in advance for you help

Re: How to hide dimension value when a column ignore the selection of this dimension?

tyagishaila — Mon, 21 Mar 2016 10:02:55 GMT

Revenue: Sum(Revenue)

TotalRevenue: Sum(Total{<Rep=>}Revenue)

Re: How to hide dimension value when a column ignore the selection of this dimension?

tyagishaila — Mon, 21 Mar 2016 10:07:23 GMT

Hope it will work

Re: How to hide dimension value when a column ignore the selection of this dimension?

PradeepReddy — Mon, 21 Mar 2016 10:09:25 GMT

1st Expression: sum(Revenue)

2nd Expression: Sum(Total{<Rep=>} Revenue)

Re: How to hide dimension value when a column ignore the selection of this dimension?

chenriot — Mon, 21 Mar 2016 14:36:54 GMT

Thanks for your answer.

It works

Re: How to hide dimension value when a column ignore the selection of this dimension?

chenriot — Mon, 21 Mar 2016 14:37:10 GMT

Thanks for your answer.

It works