Help

Sat, 10 Oct 2015 18:00:28 GMT

Hi All,

I have one column Grades which has values like Total,Net,N1,N2,N3,Profit.

I have one more column NonGrade Which is derived from Grades and contains values N1,N2,N3 and if i select one of value (ex : N1) in NonGrade I have to display values Total,Net,N1,Profit. If i click on N2 then Total,Net,N2,Profit.

I am attaching QVW also. Could you please anybody help here?

Thanks,

Vamsi

Re: Help

maxgro — Sat, 10 Oct 2015 18:28:03 GMT

change your script with

Tab1:

LOAD * Inline [

Grade,Value,Code

Total,100000,1

Net,70000,2

N1,30000,3

N2,20000,4

N3,10000,5

];

//Tab2:

//LOAD *, If(Grade ='N1' or Grade ='N2' or Grade ='N3',Grade) as NonGrade

//Resident Tab1;

//DROP Table Tab1;

Tab2:

load 'N1' as NonGrade, Grade Resident Tab1 Where not Match(Grade, 'N2', 'N3');

load 'N2' as NonGrade, Grade Resident Tab1 Where not Match(Grade, 'N1', 'N3');

load 'N3' as NonGrade, Grade Resident Tab1 Where not Match(Grade, 'N2', 'N1');

topic Re: Help in QlikView

Help

Re: Help