Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
prabhu_rutali
New Contributor

Keeping a value constant

Im having a data in which I have sales and quantity.If I divide sales upon quantity , I get a value which  changes month year wise. How can I keep this value constanti.e on selection of month year and it must not change with other fields

3 Replies

Re: Keeping a value constant

Try this

Sum{<Year=,Month=>} Sales)

Re: Keeping a value constant

If you need on other fields also not change sales value then try to add that also

Sum({<Year=,Month=>} Sales)


Or


By this all fields no selection affect

Sum( {1} Sales)

Re: Keeping a value constant

Hi Rutali, maybe?

Sum({1<YearField=P(YearField), Monthfield=P(Monthfield)>} Sales)