topic Re: How to show all the values in Straight Table when selected in QlikView

How to show all the values in Straight Table when selected

krishna20 — Mon, 07 Jul 2014 09:32:23 GMT

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

Re: How to show all the values in Straight Table when selected

avinashelite — Mon, 07 Jul 2014 09:36:29 GMT

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

Re: How to show all the values in Straight Table when selected

tresB — Mon, 07 Jul 2014 09:36:35 GMT

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.

Re: How to show all the values in Straight Table when selected

parthiband — Mon, 07 Jul 2014 09:38:18 GMT

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, !

Re: How to show all the values in Straight Table when selected

Mon, 07 Jul 2014 09:40:59 GMT

Try to by pass the company field

ex:

Sum({<Copanie=>}Sales)

Re: How to show all the values in Straight Table when selected

krishna20 — Mon, 07 Jul 2014 09:41:33 GMT

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

Re: How to show all the values in Straight Table when selected

avinashelite — Mon, 07 Jul 2014 09:45:38 GMT

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

Re: How to show all the values in Straight Table when selected

parthiband — Mon, 07 Jul 2014 09:47:09 GMT

See the attachment

Thanks,

Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 06:33:47 GMT

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

Re: How to show all the values in Straight Table when selected

Tue, 08 Jul 2014 06:53:17 GMT

Hi Kalyan,

PFA application it may solve ur issue.

Thanks,

Ashok.

Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 07:09:03 GMT

Hi Ashok.

Thank you for your reply.But in the document the selected values is not moving to the top.

Regards

Krishna

Re: Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 07:31:10 GMT

Hi Avinash

Please find the attachment..Dashoard Tab.First straight Table..I'm having many expressions..I dnt know where to place the logic.

Regards

Krishna

Re: Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 07:44:20 GMT

Hi Ashok,

Please find the attachment.IDashboard Tab-> First straight table.I have used many expressions.I dnt come to know where to place the logic which u suggested me.Pls Help me out..

Regards

Krishna

Re: Re: Re: How to show all the values in Straight Table when selected

avinashelite — Tue, 08 Jul 2014 07:55:08 GMT

Hi kalyan,

Please find the screen shot , where u need to give the logic

Re: Re: Re: How to show all the values in Straight Table when selected

avinashelite — Tue, 08 Jul 2014 08:04:15 GMT

Hi kalyan,

Please find the attachment for solution according to your requirement its populating the Selections at the top.

Please see the script and sorting option in the properties.

regards,

@vi

Re: Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 08:44:26 GMT

Hi Avinash

I did it.But the unselected values result showing as zero.Wat may be the issue?

Regards

Krishna

Re: How to show all the values in Straight Table when selected

avinashelite — Tue, 08 Jul 2014 09:13:44 GMT

Hi kalyan,

Are you using any variables in the calculation???

Please post the app let me check

Re: Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 09:20:41 GMT

Hi Avinash,

no,.i used like =sum({<COMPANY>}Amount).

for other expressions im using variable vCurrentYear.

pls find the below attachment.Dashboard tab.First table

Regards

Krishna

Re: How to show all the values in Straight Table when selected

avinashelite — Tue, 08 Jul 2014 09:39:44 GMT

Hi kalyan,

I went through your dashboard tab, i found for the company field we have only 1 value. So its showing only one company name.

If i have understood the problem wrongly please correct me.

Re: Re: How to show all the values in Straight Table when selected

krishna20 — Tue, 08 Jul 2014 09:58:19 GMT

Hi Avinash,

Pls find the screen shots.There is five companies.When i selected the company.Its placing there itself not moving to top.i sorted it by company name and then the unselected values showing zero for all results.

Pls find it in Screen shots.

Regards

Krishna