Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master II

how do i create no of variable according to row count of a table?

Hi all ,

I have a table. i want to create as no of variable depending upon no of rows in table..

My script is as given below.

Data_Table:

Load

Test

Measure

from GG_tab.qvd

let vcount= NoOfRows('Data_Table');

suppose vcount comes to be 6 in no....and data in my DATA_TABLE is like given below

Test
Measure
T1M1
T2M2
T3M3
T4M4
T5M5
T6M6

Then how can i create 6 variables like

T1_M1_V1

T2_M2_V2

T3_M3_V3

T4_M4_V4

T5_M5_V5

T6_M6_V6

Please help me to solve this problem

Thanks

sushil

0 Replies