Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
everest226
Contributor III

help with expression

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])

Tags (1)
Labels (1)
1 Solution

Accepted Solutions

Re: help with expression

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])
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
5 Replies

Re: help with expression

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

Sum({&lt;[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={"=[Dep Date]&gt;[see Date]"},[T Date]={"=[T Date]&lt;[see Date]"}&gt;}[Amount])
-
Sum({&lt;[Request Type]={'CR'},[ Action ]={'APP'},
[Dep Date]={"=[Dep Date]&gt;[see Date]"},[T Date]={"=[T Date]&lt;[see Date]"}&gt;}[Amount])
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
everest226
Contributor III

Re: help with expression

what is &lt; does in this expression . 

Re: help with expression

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])
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
everest226
Contributor III

Re: help with expression

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

If that table is not associated to any, definitely the only reason is that.
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)