topic Re: Second header based on first header in QlikView

Second header based on first header

Anonymous — Mon, 08 Feb 2016 20:22:03 GMT

Hi Community

For below example I have used valuelist('9Q Avg', '1Q16') as 3rd dimension.

I want different header for 1st column 'JO', let say valuelist('4Q15') else as mentioned above.

Any idea please?

Thanks

Re: Second header based on first header

Mon, 08 Feb 2016 20:53:19 GMT

Instead of value List, you can add the expressions directly on the expression tab.

Re: Second header based on first header

Tue, 09 Feb 2016 10:07:04 GMT

Hi Satish,

You can create a inline table for these values something like

Load * inline [

Header

'9Q Avg'

'1Q16'

];

drop this field in the dimension and edit this column with expression like

if(field='JO','4Q15',Header)

change the expression set accordingly.

Re: Second header based on first header

Anonymous — Tue, 09 Feb 2016 13:18:53 GMT

Hi Lokeshwari

This is excellent suggestion, but in expression how do I use formula like if '4Q15' than Exp1, if '9QAvg' than Exp2? Today I have posted same question again with sample QV, Please have a look.

I appreciate your efforts and time

Thanks

Re: Second header based on first header

Wed, 10 Feb 2016 05:28:08 GMT

Hi Satish,

Could you post the sample QV ?

Regards