topic help with expression in QlikView

help with expression

everest226 — Sat, 16 Nov 2024 04:38:23 GMT

I have following expression on my table . all i want is to show all the amount by the each see date , currently i have to select see date to see the value and it will only show the value of selected date, but i want this to be display all by the see date .

dimension is see date

Sum({<[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={">$(=[see Date])"},[T Date]={"<$(=[see Date])"}>}[Amount])
-
Sum({<[Request Type]={'CR'},[ Action ]={'APP'},[ Dep Date]={">$(=[see Date])"},[T Date]={"<$(=[see Date])"}>}[Amount])

Re: help with expression

Anil_Babu_Samineni — Mon, 28 Jan 2019 23:45:30 GMT

For me the expression what you did is quiet wrong, perhaps this? I am just altering your expression to proper syntax

Sum({<[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={"=[Dep Date]>[see Date]"},[T Date]={"=[T Date]<[see Date]"}>}[Amount])
-
Sum({<[Request Type]={'CR'},[ Action ]={'APP'},
[Dep Date]={"=[Dep Date]>[see Date]"},[T Date]={"=[T Date]<[see Date]"}>}[Amount])

Re: help with expression

everest226 — Tue, 29 Jan 2019 18:13:51 GMT

what is < does in this expression .

Re: help with expression

Anil_Babu_Samineni — Wed, 30 Jan 2019 00:19:03 GMT

Not sure, why this got changed. I just mentioned <= and >= like below
Sum({<[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={"=[Dep Date]>[see Date]"},[T Date]={"=[T Date]<[see Date]"}>}[Amount])
-
Sum({<[Request Type]={'CR'},[ Action ]={'APP'},
[Dep Date]={"=[Dep Date]>[see Date]"},[T Date]={"=[T Date]<[see Date]"}>}[Amount])

Re: help with expression

everest226 — Wed, 30 Jan 2019 15:15:20 GMT

Thanks @Anil_Babu_Samineni

Its gives the same result. but the value only shows when i click viewdate from listbox where as i am trying to show every viewdate value in table . is it because VIewDate is independent island in data model which is not linked to any table?

Thanks

Again

Re: help with expression

Anil_Babu_Samineni — Tue, 05 Feb 2019 00:33:52 GMT

If that table is not associated to any, definitely the only reason is that.