Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Pivot Data

Hi Team,

I had come across a scenario where I have data in my qv report (pivot table) as below:

DateNameHoursJobs
54.6533
13/11/2014A7.55
13/11/2014B4.73
13/11/2014C5.52
12/11/2014A7.51
12/11/2014C7.06
11/11/2014B6.54
11/11/2014C3.758
10/11/2014A4.73
10/11/2014B7.51

Now, I want a report which displays data in a following way, as below:

NameHoursJobs
A19.79
B18.78
C16.2516

I have tried couple of options like I have taken the 'Date' Dimension then in the Presentation Tab I selected Hide Column, but the results are incorrect.

Need your help.

Thanks,

Sindhu.

13 Replies
anbu1984
Master III
Master III

Can you post sample app

alexandros17
Partner - Champion III
Partner - Champion III

Use NAme as dimension and 2 expression Sum(Hours), Sum(Job)

let me know

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Use Name as dimension, and Sum(Hours) and Sum(Jobs) for the expressions. Or have I missed something in your requirements.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi Sindhu

You need to remove the Dimension from the pivot chart insted of hiding it.

Regards

Harsha

ashfaq_haseeb
Champion III
Champion III

Is this what you are looking at?

Regards

ASHFAQ

Not applicable
Author

HI,

I have taken User as Dimension and and Sum(Hours) and Sum(Jobs) for the expressions as expressions.

Even I have removed Date dimension, but even then its not working.

Seems to be simple, but not able to produce in the required way.


Thanks,

Sindhu

raviityou
Partner - Creator
Partner - Creator

hi,

try this hope it will help you out

set Dimensions as Name (only)

even More:- try this

you can set  date on top site of the bar to show the value by date

and rest of all same (expression and all that thinks   )

ashfaq_haseeb
Champion III
Champion III

Did you check my application.

This is simple and straight forward.

have a look at attached image.

Regards

ASHFAQ

Not applicable
Author

Hi,

Sorry I didnt get the application.

Can you please resend it.

Thanks,

Sindhu.