topic Re: Passing variable in Pivot table in QlikView

Passing variable in Pivot table

krishna20 — Sun, 12 Apr 2015 07:36:39 GMT

Hi Friends,

Is it possible to pass a variable in pivot table.My requirement is I'm having a year field CL_Year.

I need to give input value in the input box by creating variable and i'm having pivot table which is having dimension CL_year and CL_TW_Year .

For Eg;

When i give input value as 1990 in the input box, the data of 1990 could be shown in pivot table.

I know this process is possible in straight table. How could be this done in pivot table?

Regards

Krishna

krishna20 — Sun, 12 Apr 2015 08:50:16 GMT

Hi Friends,

Any Idea ?!!

Anonymous — Sun, 12 Apr 2015 12:11:11 GMT

Not clear, sorry...

Anonymous — Sun, 12 Apr 2015 13:07:08 GMT

Hi ,

First you create a variable vYear

Then create a input box and pass that variable to inputbox

Create a table and add an expressiion using variable .

ex: sum( {$<Year = {$(#vYear)}>} Sales ).

hope this will help you

Thanks

krishna20 — Sun, 12 Apr 2015 13:12:18 GMT

Hi ,

My requirement is I need to pass a year filed in the input box.

Ex:

FROM Year [Input Box] To Year [Input Box]

When inputs given in this input boxes.

The pivot table data need to shown between those years.

jagan — Mon, 13 Apr 2015 04:07:31 GMT

Hi Krishna,

Assign a variable to the Input box and use the below expression in the pivot table

variable Name = vInputYear

Sum( {$<CL_Year= {$(=vInputYear)}>} Sales )

Regards,

Jagan.

hariprasadqv — Mon, 13 Apr 2015 04:46:33 GMT

Fallow Jagan's View/