topic How to display data dynamically? in QlikView

How to display data dynamically?

Thu, 18 Jun 2015 07:23:48 GMT

Hi,

I create pivot table.and I want to display data dynamically but I do not

know how to display dynamically .pls tell me out how to display data dynamically in pivot table like this .If I select Jan in list box then pivot table show Jan data.If i select Feb in listbox then my Pivot table show jan and Feb Data.and If I select March In list box then My pivot table show Jan,Feb,March .

This is my data

LOAD Id,

CarName,

Price

FROM

(ooxml, embedded labels, table is Sheet1);

car:

LOAD

Month(Date#(RecNo(),'M')) as Month

AutoGenerate 12;

Here when I select Feb It dispaly only feb data but I want to display data like this when i select feb It dispaly Jan and feb data.If i select

Mar then pivot table display jan,feb,mar data.

Thankyou,

Regards

madhu

Re: How to display data dynamically?

settu_periasamy — Thu, 18 Jun 2015 08:47:36 GMT

Hi,

Try the attachment. In the script just i added recno() for relating the tables.

and in the expression

=Sum({<Month={">=1<=$(=Max(Month))"}>}Price)

Hope this helps.

Re: How to display data dynamically?

Fri, 19 Jun 2015 04:25:40 GMT

Thank you settu periasamy.but i can not open your document because I use qv Personal edition.pls can you keep script screen shot. pls

regards

madhu

Re: How to display data dynamically?

settu_periasamy — Fri, 19 Jun 2015 04:34:50 GMT

Hi,

Here it is:

DIRECTORY;
LOAD Id,
  RecNo(), 
     CarName,
     Price
     
FROM
Bundle1.xlsx
(ooxml, embedded labels, table is Sheet1);


LOAD
Month(Date#(RecNo(),'M')) as Month,
RecNo()
AutoGenerate 12;