Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table box

how to use variable with expression in table box to make it dayanamic.

i have value of sales of different stores with Month wise.

i want to show it in table Box Store and sales,

and by using variable vmonth, i want to see sales of store in that month.

StoreSalesMonth
asd100Jan
bds199Jan
aby344Jan
cde233Jan
wer1100Jan
kyt120Feb
tre100Feb
asd199Feb
bds344Feb
aby233Feb
cde1100Feb
wer120Mar
kyt100Mar
tre199Mar
ggh344Mar
man233Mar
nsh1100Mar

i want to use only table box.

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Table box doesn't support expressions.Why your going for table box?What makes you to choose the table box? if you provide it in briefer which makes to provide a solution to do it in different way.

Celambarasan

Not applicable
Author

i know that but when i m using chart table i m not able to get all the data some of rows

missing in table but in table box all rows showing.

i have checked many time althouh my expression and all things r right but i m not getting all values .

Only({<Month={$(vmonth)}>}sales),by using this i m not able to find all rows i m getting only few rows.