topic Re: Pivot Table Query in QlikView

Pivot Table Query

rahulsingh12 — Mon, 07 Aug 2017 07:21:10 GMT

Hi ,

In pivot table expression, I just want to display the values of a field I am pulling from database.

Is it possible to do so without using any function on that field?

If I put field in the expression I don't get anything.

Regards,

Rahul

mayuresh_d — Mon, 07 Aug 2017 07:43:45 GMT

hi,

if you don't want to show any aggregated data. then don't use pivot table. just get this values in table as it is.

if you want anything else than just to show values then please tell us your exact requirement.

it would be great help for us to understand what exactly you want.

thanks,

Mayuresh

rahulsingh12 — Mon, 07 Aug 2017 08:09:03 GMT

Hi,

i have attached the sample data set.

In straight table we see brand and its cost.

I want the same thing to be replicated in pivot table as I have date field which I will use in Pivot table.

Regards,

Rahul

mayuresh_d — Mon, 07 Aug 2017 08:57:45 GMT

hi,

find attachment,

and please tell me if i am correct.

thanks

Mayuresh