topic Re: Display Fields dynamically in straight table in QlikView

Display Fields dynamically in straight table

vikasmahajan — Wed, 22 Jun 2016 12:13:41 GMT

Find attached sheet and qvw , When user select opportunity1 then related information should display in straight table , like this user can select opportunity2 and so ..

Field Lvl Trigger : - vVariable1-> = if(InitativeNo='I1', fieldvalue('Initative', 1),if(InitativeNo='I2',fieldvalue('Initative',2)))

vVariable2-> = if(InitativeNo='I1', fieldvalue('InititiavtiveHost',1),if(InitativeNo='I2',fieldvalue('InititiavtiveHost',2)))

vVariable3-> = if(InitativeNo='I1', fieldvalue('InititiavtiveCharges',1),if(InitativeNo='I2',fieldvalue('InititiavtiveCharges',2)))

Sum($(='[' & vVariable3 & ']')) Expression

=num(Sum({<$(='[' & vVariable4 & ']') = {'Review'}>} $(='[' & vVariable3 & ']')),'$#,##0') ( Set with expression)

Thanks in ADV

Vikas

Re: Display Fields dynamically in straight table

Anonymous — Wed, 22 Jun 2016 12:18:59 GMT

I donot understand, your Chart Looks good, but is missing an expression

so define an Expression e.g. 1, then goto presentation and hide the 1

thats what you will see (if you select Opp3)

Re: Display Fields dynamically in straight table

migueldelval — Wed, 22 Jun 2016 12:24:40 GMT

Hi Vikas,

Could the attach file answer your question?

Regards

Miguel del Valle