Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

show variable input date field as a date column in table

hey everyone,

I've create two variables $(vFromDate) and  $(vFromDateTo) , where user can enter date ,

Now i want to show only that date range records(entered by the user) in the straight table.

 

 

mahnoor1279_0-1659674873132.png

 

Labels (5)
2 Replies
JHuis
Creator III
Creator III

You only want to show the dates? 

Because i think if you used a measure it would be better. 

 

Can you give an example if you want to use a measure?

PrashantSangle

you can but for that you need those dates in your master calendar.

in straight table add that date field from master calendar then use set analysis as

sum({<date_from_master_calendar={">=$(=your_start_variable)<=$(=your_end_variable)"}>}1)

then you can hide that column.

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂