Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
marqupcmb
Contributor II
Contributor II

Type of Date variable as dimension

I have 3 differents dates:

PostingDate

InvoiceDate

GIMTDate

each one is a type of activity and is on a different table

What I want to do is have a Table Box where I can select one of those dates and in the same line graphic using as dimension the date selected and as the expression the sum of the amount related.

Somebody have any ideas? I'm sure it can be done with variables but I don't get how can it be done.

1 Solution

Accepted Solutions
muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

Refer this app,

Muthukumar Pandiyan

View solution in original post

4 Replies
Anonymous
Not applicable

Do you want all the three dates and related sum in a single table box?

MarcoWedel

Hi,

maybe helpful:

Canonical Date

Radio buttons

regards

Marco

marqupcmb
Contributor II
Contributor II
Author

I want to show in the same graphics the sums by the differents dates by selecting the type of date "action"

something like this

Is not working but is the idea... I can Select the type of date and it will change on the graphic dimension

My idea is put on the graphic dimension a variable that will take the date depending on the type of date selected

Captura3.PNG

muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

Refer this app,

Muthukumar Pandiyan