Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

Pivot table column changes dynamically based on Selections

Hello Everyone,

 

I have customer requirement where customer select days from Filter pane . Based on selection days Pivot Table columns has to be changed dynamically 

 

Days

Accounts

1

100

2

500

3

579

4

235

5

456

6

213

7

153

8

259

9

153

10

123

 

Days

1

2

3

4

5

6

7

8

9

10

>1

 

 

 

 

-

-

-

-

-

-

>2

100

 

 

 

 

 

 

 

 

 

>3

-

 

 

235

456

213

153

259

153

123

>4

-

-

-

-

456

213

153

259

153

123

 

From Above selection lets Say if customer select 6 value, Pivot table should display Days 1 to 5 columns like below 

Days

1

2

3

4

5

>1

 

 

 

 

-

>2

100

 

 

 

 

>3

-

 

 

235

456

>4

-

-

-

-

456

Similarly   If customer select 8 value 

Days

1

2

3

4

5

6

7

>1

 

 

 

 

-

-

-

>2

100

 

 

 

 

 

 

>3

-

 

 

235

456

213

153

>4

-

-

-

-

456

213

153

 

Please could any one help out 

Regards,

Siva

 

0 Replies