topic Re: How to load fields dashboard wise Y/N in QlikView

How to load fields dashboard wise Y/N

vikasmahajan — Tue, 06 Dec 2016 07:56:33 GMT

Dear All,

I have fields like following structure in excel sheet , depending on flag "Y" I want to load the fields dashboard wise.

how to achieve the same ?

FieldName	Dashboard1	Dashboard2	Dashboard3	Dashboard4
Field1,	Y	Y	Y	N
Field2,	Y	Y	Y	Y
Field3,	Y	N	Y	Y
Field4,	Y	Y	N	Y
Field5,	N	Y	Y	Y

Attached excel fields.

Thanks in Adv

Vikas

Re: How to load fields dashboard wise Y/N

Anonymous — Tue, 06 Dec 2016 08:06:10 GMT

See if this helps?

Data:
CrossTable(DashboardNo,Field,1)
LOAD * INLINE [
FieldName, Dashboard1, Dashboard2, Dashboard3, Dashboard4
Field1, Y, Y, Y, N
Field2, Y, Y, Y, Y
Field3, Y, N, Y, Y
Field4, Y, Y, N, Y
Field5, N, Y, Y, Y
];

Not sure what you mean by dashboardwise??

Re: How to load fields dashboard wise Y/N

Anonymous — Tue, 06 Dec 2016 08:09:02 GMT

Or this to only select where the dashboard value is 'Y'

Temp:
CrossTable(DashboardNo,Indicator,1)
LOAD * INLINE [
FieldName, Dashboard1, Dashboard2, Dashboard3, Dashboard4
Field1, Y, Y, Y, N
Field2, Y, Y, Y, Y
Field3, Y, N, Y, Y
Field4, Y, Y, N, Y
Field5, N, Y, Y, Y
];

Data:
NoConcatenate
Load * Resident Temp where match(Indicator,'Y');

Drop table Temp;