How to show all the values in Straight Table when selected

[krishna20]

Hi friends

i'm having company dimension in straight table following calculations to that.When i selected a company.Its showing the particular company details only.I need to show all the companies when selection also.How it Overcomes.?Can any one pls help me out.

Regards

Krishna

[avinashelite]

Hi Kalyan,

Your correct, that is the nature of Qlikview it will show the data based on the selection.

If you want to show all the data in spite of selections too, you can use DETACH option > Right click on the Chart you will find the detach option.

Regards,

@vi

[tresesco]

In your expression use set expression like:

=Sum({<Company>}YourField )

Here, your expression could be different, but the point is you have to include the set '{<Company>}' in your expression with aggregation functions.

[parthiband]

Hi,

Just Nullify the dimension which u don't want to get impact on your selection.

For Example, Consider ur exp., Sum(Revenue)

Nullify it for company by,

Sum({$<Company=>}Revenue)

Thanks, !

[#5]

Try to by pass the company field

ex:

Sum({<Copanie=>}Sales)

[krishna20]

Hi Avinash.

When i selected the company in straight table the details has shown in that including the different company details.But the selected company should shown as the selected.

Regards

Krishna

[avinashelite]

Hi Kalyan,

I think their is some data associated with that, Please check that data model and data dependence once.

Can you please post your qvw file with sample data so that we can trace the problem.

Regards,

@vi

[parthiband]

See the attachment

Thanks,

[krishna20]

Hi Avinash,

I need to show in the straight table the selected values and also unselected values like a list box.The selected values should comes top and unselected values will shown at the bottom.I'm unable to post a sample file.But above one is the logic.Can you please help me out?

Regards

Krishna

[#10]

Hi Kalyan,

PFA application it may solve ur issue.

Thanks,

Ashok.