topic Re: quick help in QlikView

quick help

Thu, 15 Oct 2015 10:51:30 GMT

please find the attached file & send please provide me the solution

Re: quick help

Anonymous — Thu, 15 Oct 2015 11:04:45 GMT

describe your problem and provide a smaller example qvw

Re: quick help

Digvijay_Singh — Thu, 15 Oct 2015 11:08:25 GMT

Don't have access as having PE version, pl describe the problem.

Re: quick help

sujeetsingh — Thu, 15 Oct 2015 11:09:12 GMT

Please come up in words !

Re: quick help

Thu, 15 Oct 2015 11:21:52 GMT

I have a Straight table have done calculations achieved total values of rows.

now i need to drag those totals as columns to perform the table format of the values

I have a straight table that needs to be converted into a table with the total values of rows formed in straight table.

Attached is the sample attachment & req image .

Re: quick help

Thu, 15 Oct 2015 12:03:17 GMT

You need put the expressions as Calculated dimension in the new pivot table.

Good Lucky!

Re: quick help

Thu, 15 Oct 2015 12:08:34 GMT

hello Marcos

Thanks for the suggestion, i tried that too but its now working

could you please share me the sample app?

Re: quick help

Thu, 15 Oct 2015 12:19:42 GMT

Hello Rudolf

could you please look into the requiremnt?

Re: quick help

Thu, 15 Oct 2015 12:51:49 GMT

any help

Re: quick help

Digvijay_Singh — Thu, 15 Oct 2015 13:02:00 GMT

I don't see image attached. can you share image of what you need, cannot open qvw as having PE.

Re: quick help

Thu, 15 Oct 2015 13:09:48 GMT

hello if you open qvw the req image is in right side of the straight table.

please look into the qvw

Re: quick help

Thu, 15 Oct 2015 13:10:37 GMT

follow one example ...l

Re: quick help

miguelbraga — Thu, 15 Oct 2015 13:22:25 GMT

Using this QVW you just need to add a new expression to calculate the percentage you need like this:

=Sum([REASONNO'S])/Sum(TOTAL [REASONNO'S])

Go to "Number" and in the expression above check Fixed to 2 Decimals and check "Show Percentage". Also if you want the totals you can check in "Presentation" the "Show subtotals at bottom" in AGIN

Re: quick help

Thu, 15 Oct 2015 13:47:39 GMT

Hi Wow,

Here you go !! Have fun.

I bet you will find my complaint within the list knowing how frustrating the commute can be on these trams having experienced it first hand myself.

Sap