topic Re: Straight table in QlikView

Straight table

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all

i have a straight table but my pro is i dont want it to be affected by date

when i select the date i dont want the chart to change , but if i select on other field it should be affected.

hope you canhelp thank you,

‌

Re: Straight table

Kushal_Chawda — Tue, 22 Mar 2016 07:23:33 GMT

=Sum({<Date>} Value)

Re: Straight table

tresB — Tue, 22 Mar 2016 07:24:17 GMT

Use set in your expression like:

Sum({<DateField>} Amount)

Re: Straight table

mario-sarkis — Tue, 22 Mar 2016 07:35:09 GMT

‌but there is no amount or something to aggregate how can i do it?

Re: Straight table

Anonymous — Tue, 22 Mar 2016 07:37:56 GMT

use only function only({<DateField>} FieldName).....

Re: Straight table

Kushal_Chawda — Tue, 22 Mar 2016 07:40:22 GMT

If you have straight table then you should have expression in your straight table. So in each expression you need to write the set analysis like this

{<Date>}

Re: Straight table

tresB — Tue, 22 Mar 2016 07:40:45 GMT

How does your expression look like?

Re: Straight table

mario-sarkis — Tue, 22 Mar 2016 07:42:43 GMT

‌my expression look like this:

=if(date <=today()-6,date)

Re: Straight table

avinashelite — Tue, 22 Mar 2016 07:43:43 GMT

you can use the only() function only({<DateField>} pro )

Re: Straight table

tamilarasu — Tue, 22 Mar 2016 07:43:57 GMT

Hi,

Try like below,

=if(date <=today()-6,Only({<Date>}date))

=if(date <=today()-6,Only({<Date= >}date))

Re: Straight table

Digvijay_Singh — Tue, 22 Mar 2016 07:55:08 GMT

Try this, it may work based on what dimension you have selected -

Max({<Date=>}if(Date <=today()-2,Date(Date)))

Re: Straight table

mario-sarkis — Tue, 22 Mar 2016 07:56:56 GMT

‌it didnt work unfortunatly

Re: Straight table

tamilarasu — Tue, 22 Mar 2016 08:21:16 GMT

Try this,

Only({<date={"<=$(=Date(Today()-6))"}>}date)

Re: Straight table

tresB — Tue, 22 Mar 2016 08:24:15 GMT

=Only({<date>}if(date <=today()-6,date))

Re: Straight table

tyagishaila — Tue, 22 Mar 2016 09:13:22 GMT

PFA,

Create new Datefield with this expression

Only({<Date=>}Date)

and use this new Datefield in your expression

if(Date1 <= today()-6 , Date1)

Re: Straight table

Anonymous — Tue, 22 Mar 2016 09:32:55 GMT

only function is use for requirement