Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chaitanyahublik
Contributor II
Contributor II

Using column value as column header dynamically

Hi Guys,

I have sample data in QVD as attached spreadsheet. I want to build pivot out of this like 

StateCity O/N1_day2_day
     
     
     

 

Now Col1/2/3 will take expression from QVD as  SUM(<{Ref={MarketValue} BUCKETX}>)   .. where X = 1,2,3.  But for header , I want to display value of 2nd row i.e. Tenor which is dynamic and it can change everyday. 

For example , Col1 will have Tenor as O/N today but it can have tenor 1_day tomorrow. So its dynamicaaly to be shown in column header. ANy idea on how to get this dynamic header from column values ?

TIA.

Labels (3)
1 Reply
chaitanyahublik
Contributor II
Contributor II
Author

there was issue with excel upload, test data in QVD is as below 

StateCityRefBUCKET1BUCKET2BUCKET3
--TenorO/N2_day3_day
FLMiamiMarketValue-59,885,058,092.9197-893,231,883,433.0270-204,406,740,331.6530
TXDallasMarketValue-1,117,544,734.9430-15,443,447,252.8691-2,780,508,149.9725
PAPhiladelphiaMarketValue---
TXHoustonMarketValue-38,003,812,443.2863-383,259,192,418.6180-948,509,760.4878
GAAtlantaMarketValue--143,171,900.9878-134,870,299.6960
DCWashingtonMarketValue---
MABostonMarketValue15,489,322,803.541630,011,122,926.968734,293,334,370.3408
WASeattleCashflowAmtGBP---
CASan FranciscoCashflowAmtGBP-168,766,486.1050-5,584,362,669.0005-1,456,089,884.4835
MIDetroitCashflowAmtGBP-209,171,827.2647-332,398,243.1590-18,936,290.9839
CASan DiegoCashflowAmtGBP---
MNMinneapolisCashflowAmtGBP---
FLTampaCashflowAmtGBP-21,553,471,049.2891-69,652,991,402.2200-42,600,152,380.6073