Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
marqupcmb
New 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
Partner
Partner

Re: Type of Date variable as dimension

Hi,

Refer this app,

Muthukumar Pandiyan

View solution in original post

4 Replies
laddu_927
Valued Contributor

Re: Type of Date variable as dimension

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

Re: Type of Date variable as dimension

Hi,

maybe helpful:

Canonical Date

Radio buttons

regards

Marco

marqupcmb
New Contributor II

Re: Type of Date variable as dimension

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

Partner
Partner

Re: Type of Date variable as dimension

Hi,

Refer this app,

Muthukumar Pandiyan

View solution in original post