topic Re: Display only selected value in staright table in QlikView

Display only selected value in staright table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am stuck with a scenario where I need experts advice.

I have a table with two columns Type and Value.

Type columns has 3 values -"op", "non-op" and "ex op".

In a straight table I want to display sum of values based on each type.

My expression are

Op exp - Sum({<type={'op'}>}value)

Sum({<type={'non-op'}>}value)

Sum({<type={'ex op'}>}value)

Now I want that if I select 'op' in list box I should get its value and remaining columns should display 0.

Thanks

Re: Display only selected value in staright table

sunny_talwar — Wed, 15 Feb 2017 19:32:33 GMT

Why don't you create a straight table like this:

Dimension

Type

Expression

Sum(value)

On the presentation tab, uncheck 'Suppress Zero Values' to show 0 values.

Re: Display only selected value in staright table

Wed, 15 Feb 2017 19:36:17 GMT

The requirement is to show all three columns by default but if a user select any value in list box then it should display that value online and remaining columns will show 0 as value

Re: Display only selected value in staright table

sunny_talwar — Wed, 15 Feb 2017 19:38:44 GMT

That is what the above will do

Re: Display only selected value in staright table

sunny_talwar — Wed, 15 Feb 2017 19:41:10 GMT

Try this as your expression:

=Sum(Value) + Avg({1} 0)

Re: Display only selected value in staright table

Wed, 15 Feb 2017 19:50:06 GMT

Sorry, but I missed to say that dimensions is a country column.

Re: Display only selected value in staright table

sunny_talwar — Wed, 15 Feb 2017 19:55:11 GMT

Then create a pivot table and have two dimensions